01 of 06
Tanga SQL Server Agent Service
SQL Server Agent inokubvumira kushandura zvakasiyana siyana zvekuita mabasa. Chimwe chezvinhu izvi chinosanganisira kushandisa SQL Server Agent kugadzira nekugadzirisa basa iro rinoshandisa dare rekutungamirira.
Vhura Mutambo weSquL Server yeMicrosoft Manager uye tsvaga SQL Server Agent service. Kana iyo iyo yebasa iri "RUNNING," haufaniri kuita chero chinhu. Kana zvisina kudaro, chengetedza kurudyi paSQL Server Agent service uye sarudza Tanga kubva pane-pop-up menu kuti uzarure Vekutangira Service window.
Cherechedza : Nyaya ino inoshanda kuSQL Server 2008. Kana uri kushandisa shanduro yeSQL Server, ungada kuverenga Kugadzira SQL Server Agent muSQL Server 2012 .
02 of 06
Vhura SQL Server Management Studio uye Wedzera SQL Server Agent Folder
Vhura SQL Server Configuration Manager uye uzarurire SQL Server Management Studio. MuSMSMS, wedzera faira yeSquL Server Agent.
03 of 06
Shandisa SQL Server Agent Job
Sarudza-bhora paMabasa folder uye sarudza Hasha Job kubva pakatanga-up menu. Zadza muZita rezita nezita rakasiyana nedzebasa rako (kuva rinotsanangurwa richakubatsira kutarisira mabasa ari nani mumugwagwa). Tsanangura 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.
Mushure mokutaura zita uye muridzi, sarudza chimwe chezvakafanirwa mabasa emhando kubva pakaderera pasi. Somuenzaniso, iwe ungasarudza "Database Maintenance" muchikwata chekuita mabasa ekugadzirisa.
Shandisa iyo huru Tsanangudzo yemumunda mazano kuti upe tsanangudzo yakajeka yechinangwa chebasa racho. Nyora nenzira yakadai yokuti munhu (iwe pachako akabatanidza) aizokwanisa kutarisa makore akawanda kubva ikozvino uye kunzwisisa chinangwa chebasa.
Pakupedzisira, chengetedza kuti bhokisi rakagadziriswa rinoongororwa.
04 of 06
Pinda muSquL Server Agent Job Maitiro Screen
Kune rumwe rutivi rworuboshwe rweEnd Job yewindo, iwe uchaona Imwe Nhanho pasi pe "Sarudza peji" inotungamirira. Dzvanya iyi icon kuti uone zvisina basa Job Step List.
05 of 06
Wedzera SQL Server Agent Job Job
Wedzera matanho ega ega ebasa racho. Dzvanya Bhatani Mutsva kuti ugadzire danho idzva rebasa uye iwe uchaona New Job Step window.
Shandisai Zita Rokutanga bhokisi bhokisi kuti upe zita rinotsanangurwa reChechi.
Shandisa Dhesi rezasi rebhokisi rekushandisa kuti usarudze dhesi iyo basa richaita.
Pakupedzisira, shandisa Command Command box kuti ipe syntax yaTransact-SQL inoenderana neyakada kuita kwechikamu chebasa. Mushure mekunge mazadza kupinda murairo, chengetera bhatani reParse kuti uone kuti syntax.
Mushure mokugadzirisa kubudirira ma syntax, tora OK kuti utange danho. Dzokorora urongwa uhwu kakawanda sezvinodiwa kuti ujekese basa raSquL Server Agent raidiwa.
06 of 06
Rongedza SQL Server Agent Jobho
Ita purogiramu yebasa nekunyanya paIndaneti icon pane Sarudza Chikamu chePeji cheNew Job window. Iwe uchaona New Job Schedule window.
Ipa zita rechirongwa muZita rebhokisi bhokisi uye sarudza purogiramu yepurogiramu-Rimwe-nguva, Kudzoka, Kutanga apo SQL Server Agent Inotanga kana Kutanga Apo CPUs Inosvibisa-kubva kubhokisi rezasi. Shandisa zvikamu zvehuwandu nehuwandu hwehwindo kuti utaure zviyero zvemabasa. Kana wapedza, tora OK kuti uvhare paIndaneti yepaIndaneti uye wakarurama kuti uite basa.