01 ngo-06
Qala inkonzo ye-Agent ye-SQL Server
Ummeli we-SQL Server uvumela ukuba uzenzele imisebenzi eyahlukeneyo yolawulo. Enye yale mi sebenzi iquka ukusebenzisa i-SQL Server Agent ukudala nokucwangcisa umsebenzi owenza ulawulo lweenkcukacha.
Vula iMenenja yokuCwangcisa iMicrosoft SQL Server kwaye ufumane inkonzo ye-SQL Server Agent. Ukuba imeko yeso senkonzo i-"RUNNING," akudingeki wenze nantoni na. Ngaphandle koko, nqakraza ngakwesokudla kwinkonzo ye-Agent SQL Server kwaye ukhethe Qalisa kwimenyu yokuphumla ukuvula iwindi yeNkonzo yokuQala.
Qaphela : Eli nqaku lisebenza kwi-SQL Server 2008. Ukuba usebenzisa inguqu kamva yeSquL Server, ungathanda ukufunda Ukulungiswa kwe-SQL Server Agent kwi-SQL Server 2012 .
02 we-06
Vula i-SQL Server Management Studio kwaye ukwandise ifolda ye-Agent SQL Server
Vala umphathi we-SQL Server Configuration Manager kwaye uvule i-SQL Server Management Studio. Kwi-SSMS, kwandisa ifolda ye-SQL Server Agent.
03 we-06
Yakha i-Job Sentsimbi ye-SQL Server
Nqakraza ngakwesokudla kwiphepha leMisebenzi uze ukhethe uNobumba Omtsha kwimenyu yokuqala. Gcwalisa insimi yegama ngegama elilodwa lomsebenzi wakho (ukuchazela kuya kunceda ukulawula imisebenzi engcono phantsi kwendlela). Cacisa i-akhawunti ofuna ukuba ngumnikazi womsebenzi kwibhokisi yombhalo womnini. Umsebenzi uza kuhamba kunye neemvume zale akhawunti kwaye ingatshintshwa kuphela ngumnikazi okanye amalungu e-sysadmin.
Emva kokuba ucacise igama kunye nomnini, khetha enye yamacandelo emisebenzi ebekwe ngaphambili ukusuka kuhlu lokuhlahla. Umzekelo, unokhetha i "Ugcino lweSitoreji seNgcaciso" kwimisebenzi yokugcina yesondlo.
Sebenzisa insimba enkulu Inkcazelo yenkcazo ukunika inkcazo ecacileyo ngenjongo yomsebenzi. Yibhale ngendlela enokuthi umntu (udibanisile) uza kukhangela iminyaka emininzi ukususela ngoku kwaye uyayiqonda injongo yomsebenzi.
Ekugqibeleni, qinisekisa ukuba ibhokisi elinikeziweyo lihlolwe.
04 we-06
Faka iSagcino seSquL Server I-Job Steps Screen
Ngakwesobunxele kwiphepha elitsha leJobhi, uza kubona i- Steps icon phantsi kwesihloko esithi "Khetha iphepha". Cofa le icon ukuze ubone uluhlu olungenanto lweSigaba seNyathelo.
05 ka 06
Yongeza ummeli we-SQL Server Job Steps
Yongeza amanyathelo omsebenzi ngamnye. Cofa iqhosha elitsha ukudala isinyathelo somsebenzi omtsha uze ubone iNew Job Job Step window.
Sebenzisa ibhokisi leNqanaba leNqaku ukunika igama elichazayo kwiNyathelo.
Sebenzisa ibhokisi lokuhla-phantsi kweDatabase ukukhetha isiseko esiza kusebenza ngalo msebenzi.
Ekugqibeleni, sebenzisa ibhokisi yombhalo we- Command ukubonelela nge-syntax ye-Transact-SQL ehambelanayo nesenzo esifunelwe kulo msebenzi. Emva kokugqiba kokungena kumyalelo, nqakraza iqhosha leParse ukuqinisekisa i-syntax.
Emva kokuqinisekisa ngempumelelo i syntax, cofa u- OK ukudala inyathelo. Phinda le nkqubo kaninzi kangangoko kunyanzelekile ukucacisa umsebenzi we-SQL Server Agent.
06 we-06
Shedyuli ye-SQL Server Agent Job
Hlela ishedyuli yomsebenzi ngokuchofoza isithonjana seShedyuli kwiSahlulo sekhasi seNew Job window. Uza kubona iWindows Job entsha yeShedyuli .
Nika igama le shedyuli kwibhokisi yegama lomxholo uze ukhethe uhlobo lweshedyuli-Ixesha elilodwa, Ukuphindaphinda, Qala xa ummeli we- SQL Server iqalisa okanye Qala xa ii-CPU ziba yi-Idle-ukusuka kwibhokisi ehlayo. Sebenzisa amaqendu kunye nobude befestile ukucacisa iiparameters zomsebenzi. Xa ugqibile, cofa u- OK ukuvala ifowuni yeShedyuli kwaye ulungile ukudala umsebenzi.