I-SQL Server Agent ikuvumela ukuba uguqule imisebenzi ehlukahlukene yokuphatha. Kulesi sifundo, sihamba ngenqubo yokusebenzisa i-SQL Server Agent ukudala nokuhlela umsebenzi owenza ukuphathwa kwedatha. Lokhu kufundisa kuqondile kwi- SQL Server 2012 . Uma usebenzisa inguqulo yangaphambilini ye-SQL Server, ungase ufise ukufunda Ukuzenzekelayo Ukuphatha Database kanye ne-SQL Server Agent . Uma usebenzisa inguqulo yakamuva ye-SQL Server, ungase ufise ukufunda Ukulungisa i-SQL Server Agent ye-SQL Server 2014.
01 ka-06
Ukuqala i-SQL Server Agent ku-SQL Server 2012
Vula iMenenja ye-Microsoft SQL Server Configuration Manager bese uchofoza ku-"SQL Services Services" ngakwesokunxele. Khona-ke, ngakwesokudla, thola isevisi ye-SQL Server Agent. Uma isimo saleyo nsizakalo singu "RUNNING", akudingeki wenze noma yini. Uma kungenjalo, chofoza ngakwesokudla isevisi ye-Agent SQL Server bese ukhetha Qala kumenyu evaliwe. Isevisi izoqala ukusebenza.
02 ka 06
Shintshela ku-SQL Server Management Studio
Vala SQL Server Configuration Manager futhi uvule SQL Server Management Studio. Ngaphakathi kwe-SSMS, yandisa ifolda ye-SQL Server Agent. Uzobona amafolda anwetshiwe aboniswe ngenhla.
03 ka 06
Dala isenzo se-SQL Server Agent
Okulandelayo, chofoza ngakwesokudla kwifolda yeMisebenzi bese ukhetha uJobe Omusha kusukela kwimenyu yokuqala. Uzobona iwindi elisha lokudala iJobe eliboniswe ngenhla. Gcwalisa insimu yegama ngegama eliyingqayizivele lomsebenzi wakho (ukuchazayo kuzokusiza ukuphatha imisebenzi engcono emgwaqeni!). Cacisa i-akhawunti oyifisa ukuba ngumnikazi womsebenzi ebhokisini lombhalo womnikazi. Umsebenzi uzosebenza ngezimvume zale akhawunti futhi ingaguqulelwa kuphela ngumnikazi noma amalungu e-sysadmin.
Uma usubeke igama kanye nomnikazi, khetha eyodwa yezigaba zomsebenzi ochazwe ngaphambilini ohlwini lokudonsa phansi. Isibonelo, ungase ukhethe isigaba se-"Database Maintenance" emisebenzini yesondlo yesimiso .
Sebenzisa insimu enkulu yesichazelo sombhalo ukuze unikeze incazelo eningiliziwe yenhloso yomsebenzi wakho. Yibhale ngendlela yokuthi othile (uqobo ufakiwe!) Uzokwazi ukuyibuka iminyaka eminingana kusukela manje futhi aqonde injongo yomsebenzi.
Ekugcineni, qinisekisa ukuthi ibhokisi elinikeziwe lihloliwe.
Ungacindezeli okwamanje nje - sinokuningi okumele kwenziwe kule window!
04 ka 06
Buka izinyathelo ze-Job
Ngakwesokunxele sewindi elisha leJobe, uzobona isithonjana sezinyathelo ngaphansi kwesihloko esithi "Khetha ikhasi". Chofoza lesi sithonjana ukuze ubone okungekho lutho lwe-Job Step Step eboniswe ngenhla.
05 ka 06
Yakha Isinyathelo Sokusebenza
Okulandelayo, uzodinga ukwengeza izinyathelo eziqondene nomsebenzi wakho. Chofoza inkinobho entsha ukudala isinyathelo somsebenzi omusha futhi uzobona i-New Yobu Step Step window eboniswe ngenhla.
A
Sebenzisa ibhokisi lokubhala le-Step Name ukuze unikeze igama elichazayo lesinyathelo.
Sebenzisa ibhokisi lokudonsela phansi le-Database ukuze ukhethe idatha ukuthi umsebenzi uzokwenza.
Okokugcina, sebenzisa ibhokisi lokubhala le-Command ukuze unikeze i-syntax ye-Transact-SQL ehambelanayo nesenzo esifunyiwe salesi sinyathelo somsebenzi. Uma usuqedile ukufaka umyalo, chofoza inkinobho yeParse ukuze uqinisekise i-syntax.
Ngemva kokuqinisekisa ngempumelelo i-syntax, chofoza u-OK ukudala isinyathelo. Phinda le nqubo izikhathi eziningi njengoba kunesidingo ukuze uchaze umsebenzi oyifunayo we-SQL Server Agent.
06 ka-06
Hlela uhlelo lwakho lwe-SQL Server Agent 2012 UJobe
Okokugcina, uzofuna ukusetha isimiso somsebenzi ngokuchofoza isithonjana seSheduli ku-Khetha ingxenye yekhasi leWebhu ye-New Job. Uzobona iwindi le-New Job schedule eliboniswe ngenhla.
Nikeza igama leshejuli ebhokisini lombhalo Wegama bese ukhetha uhlobo lwesimiso (Isikhathi esisodwa, Ukuphindaphindiwe, Qala lapho i-SQL Server Agent iqalisa noma Qala Uma ama-CPU eba yize) kusukela ebhokisini lokudonsa. Bese sebenzisa izigaba zamaningi nezikhathi zefasitela ukuze ucacise imingcele yomsebenzi. Uma usuqedile uchofoze OK ukuvala ifasitela leSheduli futhi ulungile ukudala umsebenzi.