Ummeli we-SQL Server uvumela ukuba uzenzele imisebenzi eyahlukeneyo yolawulo. Kule tutorial, sihamba kwinkqubo yokusebenzisa i-SQL Server Agent ukudala nokucwangcisa umsebenzi owenza ulawulo lokugcina idatha. Olu qeqesho lucacile kwiSQL Server 2012 . Ukuba usebenzisa inguqu yangaphambili yeService Server, ungathanda ukufunda Ukuzenzekelayo Ukulawulwa Kweedatha kunye ne-Agent SQL Server . Ukuba usebenzisa inguqu kamva yeSQL Server, unokufisa ukufunda Ukuqwalasela i-SQL Server Agent ye-SQL Server 2014.
01 ngo-06
Ukuqala Ummeli weSQL Server kwiSQL Server 2012
Vula uMphathi we-Microsoft SQL Server Configuration Manager kwaye nqakraza kwi "SQL Server Services" kwiphepha lekhohlo. Emva koko, kwicala lokunene, khangela isevisi ye-SQL Server Agent. Ukuba imeko yeso senkonzo i-"RUNNING", akudingeki wenze nantoni na. Ngaphandle koko, nqakraza ngakwesokudla kwi-SQL Server Agent isevisi uze ukhethe Qalisa kwimenyu yokuphumayo. Inkonzo iya kuqala ukusebenza.
02 we-06
Shintshela kwi-Studio ye-SQL Server Management Studio
Vala umphathi we-SQL Server Configuration Manager kwaye uvule i-SQL Server Management Studio. Kwi-SSMS, kwandisa ifolda ye-SQL Server Agent. Uza kubona iifolda ezandisiweyo eziboniswe ngasentla.
03 we-06
Yakha i-Job Agent Job
Emva koko, nqakraza ngakwesokudla kwiphepha leMisebenzi uze ukhethe uNobumba omtsha kwimenyu yokuqala. Uza kubona iWindows Job entsha yewindow eboniswe ngasentla. Gcwalisa indawo yegama ngegama elikhethekileyo lomsebenzi wakho (ukuchazela kuya kukunceda ukuphatha imisebenzi engcono phantsi kwendlela!). Cacisa i-akhawunti enqwenela ukuba ngumnikazi womsebenzi kwibhokisi yombhalo womnini. Umsebenzi uza kuhamba kunye neemvume zale akhawunti kwaye ingatshintshwa kuphela ngumnikazi okanye amalungu e-sysadmin.
Xa usukhankanyile igama kunye nomnini, khetha enye yamacandelo emisebenzi ebekwe ngaphambili kwiluhlu lokuhlahla. Umzekelo, unokhetha i "Ugcino lweSitoreji seNgcaciso" kwimisebenzi yokugcina yesondlo .
Sebenzisa inkcazo enkulu yeenkcazo yenkcazo ukuze unikezele inkcazo ecacileyo ngenjongo yomsebenzi wakho. Yibhale ngendlela enjengokuthi umntu (uqulethe!) Uya kukwazi ukuwujonga iminyaka emininzi ukususela ngoku kwaye uyayiqonda injongo yomsebenzi.
Ekugqibeleni, qinisekisa ukuba ibhokisi elinikeziweyo lihlolwe.
Musa ukuchofoza i-OK nje-sinokuningi ukwenza kule festile!
04 we-06
Jonga iYobby Steps
Ngakwesobunxele kwiphepha elitsha leJobhi, uza kubona i-Steps icon phantsi kwesihloko esithi "Khetha iphepha". Cofa le icon ukuze ubone uluhlu olungenanto lwentsebenzo eboniswe ngasentla.
05 ka 06
Yenza isinyathelo seJobe
Emva koko, kuya kufuneka ungeze amanyathelo omsebenzi wakho. Cofa iqhosha elitsha ukudala isinyathelo esitsha somsebenzi kwaye uza kubona iWindows Job Step Step window eboniswe ngasentla.
A
Sebenzisa ibhokisi legama leNqanaba lokunika igama elichazayo kwiNyathelo.
Sebenzisa ibhokisi lokuhla-phantsi kweDatabase ukukhetha isiseko esiza kusebenza ngalo msebenzi.
Ekugqibeleni, sebenzisa ibhokisi lebhokisi yokuLawula ukubonelela nge-syntax ye-Transact-SQL ehambelana nesenzo esifunelwe kulo msebenzi. Emva kokuba ugqibe ukufaka umyalelo, nqakraza iqhosha leParse ukuqinisekisa i-syntax.
Emva kokuqinisekisa ngempumelelo i syntax, cofa u-OK ukudala inyathelo. Phinda le nkqubo kaninzi kangangoko kuyimfuneko ukuchaza umsebenzi wakho we-SQL Server Agent.
06 we-06
Shedyuli ummeli wakho we-SQL Server 2012 Job
Ekugqibeleni, uya kufuna ukuseta ishedyuli yomsebenzi ngokuchofoza uphawu lweShedyuli kwiSahlulo sekhasi seNew Job window. Uza kubona iWindows Job entsha yeshedyuli eboniswe ngasentla.
Ukunikezela igama le shedyuli kwibhokisi legama legama kwaye ukhethe uhlobo lwenkqubo (ixesha elilodwa, eliphindaphindiweyo, Qala xa ummeli we-SQL Server eqala okanye Qala xa ii-CPU ziba yiNqabileyo) ukusuka kwibhokisi ehlayo. Emva koko sebenzisa amaqendu kunye nobude befestile ukuze uchaze iiparameters zomsebenzi. Xa uqedile qhosha uVala ukuvala ifowuni yeShedyuli kwaye ulungile ukudala umsebenzi.