01 ka-06
Qala isevisi ye-Agent ye-SQL Server
I-SQL Server Agent ikuvumela ukuba uguqule imisebenzi ehlukahlukene yokuphatha. Omunye walezo zisebenzi kuhilela ukusebenzisa i-SQL Server Agent ukudala nokuhlela umsebenzi owenza ukuphathwa kwedatha.
Vula iMenenja Yokucushwa kwe-Microsoft SQL Server bese uthola isevisi ye-SQL Server Agent. Uma isimo salosi sevisi "SIKHUMA," akudingeki wenze noma yini. Uma kungenjalo, chofoza ngakwesokudla isevisi ye-Agent SQL Server bese ukhetha Qala kusuka kwimenyu e-pop-up ukuze uvule iwindi leNsiza yokuQala.
Qaphela : Lesi sihloko sisebenza ku-SQL Server 2008. Uma usebenzisa inguqulo yakamuva ye-SQL Server, ungase ufune ukufunda Ukulungisa i-SQL Server Agent ku-SQL Server 2012 .
02 ka 06
Vula iSofthiwe Yokwengamela I-SQL Server futhi Yandisa Ifolda Yama Agent SQL Server
Vala SQL Server Configuration Manager futhi uvule SQL Server Management Studio. Ngaphakathi kwe-SSMS, yandisa ifolda ye-SQL Server Agent.
03 ka 06
Dala i-New SQL Server Agent Job
Chofoza ngakwesokudla kwifolda yeMisebenzi bese ukhetha uJobe Omusha kwimenyu yokuqala. Gcwalisa insimu yegama ngegama eliyingqayizivele lomsebenzi wakho (ukuchazayo kuzokusiza ukuphatha imisebenzi engcono emgwaqweni). Cacisa i-akhawunti ofuna ukuba ngumnikazi womsebenzi ebhokisini lombhalo womnikazi. Umsebenzi uzosebenza ngezimvume zale akhawunti futhi ingaguqulelwa kuphela ngumnikazi noma amalungu e-sysadmin.
Ngemuva kokuthi ucacise igama 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. Yibhale ngendlela yokuthi umuntu (ozifakile) uzokwazi ukuyibuka iminyaka eminingana kusukela manje futhi aqonde injongo yomsebenzi.
Ekugcineni, qinisekisa ukuthi ibhokisi elinikeziwe lihloliwe.
04 ka 06
Faka i-SQL Server Agent I-Job Steps Screen
Ngakwesokunxele sewindi elisha leJobe, uzobona isithonjana sezinyathelo ngaphansi kwesihloko esithi "Khetha ikhasi". Chofoza lesi sithonjana ukuze ubone uhlu olungenalutho lwe-Job Step List.
05 ka 06
Engeza i-SQL Server Agent Job Steps
Engeza izinyathelo ngabanye zomsebenzi. Chofoza inkinobho entsha ukudala isinyathelo somsebenzi omusha futhi uzobona i-New Job Step window.
Sebenzisa ibhokisi le- Step Name umbhalo ukuze unikeze igama elichazayo leNyathelo.
Sebenzisa ibhokisi lokudonsela phansi le- Database ukuze ukhethe idatha ukuthi umsebenzi uzokwenza.
Okokugcina, sebenzisa ibhokisi lokubhala lomyalo ukuze unikeze i-syntax ye-Transact-SQL ehambelanayo nesenzo esifunyiwe salesi sinyathelo somsebenzi. Ngemuva kokuba uqedile ukufaka umyalo, chofoza inkinobho ye- Parse ukuqinisekisa i-syntax.
Ngemva kokuqinisekisa ngempumelelo i-syntax, chofoza u- OK ukudala isinyathelo. Phinda le nqubo izikhathi eziningi njengoba kunesidingo ukuze uchaze umsebenzi oyifunayo we-Agent SQL Server.
06 ka-06
Hlela umsebenzi we-SQL Server Agent Job
Setha isimiso somsebenzi ngokuchofoza isithonjana seSheduli ku-Khetha ingxenye yekhasi leWebhu ye- New Job . Uzobona iwindi le- New Job Schedule .
Nikeza igama leshejuli ebhokisini lombhalo wegama bese ukhetha uhlobo lwesimiso-Isikhathi esisodwa, Isikhathi esiphezulu, Qala lapho i- SQL Server Agent iqalisa noma Qala Uma ama-CPU eba yize-kusukela ebhokisini lokudonsa. Sebenzisa izigaba zamaningi nezikhathi zefasitela ukuze ucacise imingcele yomsebenzi. Uma usuqedile, chofoza u- KULUNGILE ukuvala iwindi leshejuli bese ulungile ukudala umsebenzi.