SQL Server Agent inokubvumira kushandura zvakasiyana siyana zvekuita mabasa. Muchidzidzo ichi, tinofamba kuburikidza nekushandiswa kweSQL Server Agent kugadzira uye kuronga basa iro rinogadzirisa dhigirizhonga yedhesi. Iyi dzidzo yakananga kune SQL Server 2012 . Kana uri kushandisa shanduro yekare yeSQL Server, unogona kuda kuverenga Automating Database Administration ne SQL Server Agent . Kana uri kushandisa shanduro yakatevera yeSQL Server, unogona kuda kuverenga Kugadzira SQL Server Agent yeSQL Server 2014.
01 of 06
Kutanga SQL Server Agent muSQL Server 2012
Vhura Microsoft SQL Server Configuration Manager uye tora pane "SQL Server Services" chinhu chiri kuruboshwe. Zvadaro, pane zviripo pane, ona SQL Server Agent service. Kana iyo iyo yebasa iri "RUNNING", haufaniri kuita chero chinhu. Kana zvisina kudaro, chengeta-chengetedza paSQL Server Agent service uye sarudza Tanga kubva pane-pop-up menu. Basa racho rinotanga kushanda.
02 of 06
Shandura kuSQL Server Management Studio
Vhura SQL Server Configuration Manager uye uzarurire SQL Server Management Studio. MuSMSMS, wedzera faira yeSquL Server Agent. Uchaona mahwindo akawedzerwa akaratidzwa pamusoro apa.
03 of 06
Gadzira SQL Server Agent Job
Zvadaro, penya-panda paWatch folder uye sarudza Hasha Job kubva pakatanga-up menu. Uchaona vheji rekushanda kweJobho rakaratidzwa pamusoro. Zadza muZita rezita rine zita rakasiyana nedzimwe rebasa rako (kuva rinotsanangurwa richakubatsira iwe kutarisira mabasa ari nani mumugwagwa!). Rondedzera iyo iyo yaunoda kuva muridzi webasa iri muMugovera bhokisi bhokisi. Basa racho richashanda nemvumo yebhuku iyi uye inogona kuchinjwa chete nemuridzi kana sysadmin nhengo dzezvematongerwo enyika.
Kana uchinge wataura zita uye muridzi, sarudza chimwe chezvinhu zvakagara zvataurwa mabasa kubva pakaderera pasi. Somuenzaniso, iwe ungasarudza "Database Maintenance" muchikwata chekuita mabasa ekugadzirisa .
Shandisa iyo huru Tsanangudzo yemumunda mazano kuti upe tsanangudzo yakajeka yechinangwa chebasa rako. Nyora nenzira yakadai kuti munhu (iwe pachako akabatanidza!) Aigona kutarisa makore akawanda kubva zvino uye kunzwisisa chinangwa chebasa racho.
Pakupedzisira, chengetedza kuti bhokisi rakagadziriswa rinoongororwa.
Usatora OK pane zvakadaro - tine zvakawanda zvokuita muhwindo iri!
04 of 06
Ona Job Job
Kune rumwe rutivi rworuboshwe rweEnd Job yewindo, iwe uchaona Imwe Nhanho pasi pe "Sarudza peji" inotungamirira. Dzvanya iyi chiratidzo kuti uone zvisina basa Job Step List inoratidzwa pamusoro apa.
05 of 06
Gadzira Job Job
Zvadaro, iwe unoda kuwedzera matanho ega ebasa rako. Dzvanya Bhatani Mutsva kuti ugadzire danho idzva rebasa uye iwe uchaona New Job Step window yakaratidzwa pamusoro apa.
A
Shandisai Zita Rokutanga Bhokisi remashoko kuti upe zita rinotsanangurwa reDanho.
Shandisa Dhesi rezasi rebhokisi rekushandisa kuti usarudze dhesi iyo basa richaita.
Pakupedzisira, shandisa Command Command mabhokisi kuti upe syntax yaTransact-SQL inowirirana nezvinodiwa nokuda kwechikamu chebasa. Kana wati wapedza kupinda murairo, chengetera bhatani reParse kuti uone mazwi e syntax.
Mushure mokugadzirisa kubudirira ma syntax, tora OK kuti utange danho. Dzokorora urongwa uhwu kakawanda sezvinodiwa kuti ujekese basa raunoda SQL Server Agent.
06 of 06
Ronga SQL Server Agent yako 2012 Job
Pakupedzisira, iwe unoda kuisa purogiramu yebasa nekudhonza icon yeChirongwa muSarudza Tsamba peji yeNew Job window. Iwe uchaona yeNew Job Job window yakaratidzwa pamusoro apa.
Ipa zita rechirongwa muZita rebhokisi bhokisi uye sarudza purogiramu yemaitiro (Rimwe-nguva, Recurring, Tanga apo SQL Server Agent inotanga kana Kutanga apo CPUs Inosvibisa) kubva kubhokisi rezasi. Zvadaro shandisa zvikamu zvehuwandu uye zvenguva yewindo kuti utaure zviyero zvemabasa. Paunenge wapedza tora OK kuti uvhare firiji Rheji uye OK kuti uite basa.