Wothandizira SQL Server amakulolani kuti muzitha kugwira ntchito zosiyanasiyana. Mu phunziroli, tikuyenda kudzera mu SQL Server Agent kuti tipeze ndikukonzekera ntchito yomwe imagwira ntchito yosamalira deta. Maphunzirowa ndi enieni kwa SQL Server 2012 . Ngati mukugwiritsa ntchito SQL Server yoyamba, mungafune kuwerenga Automating Database Administration ndi SQL Server Agent . Ngati mukugwiritsa ntchito SQL Server yotsatira, mukhoza kuwerenga Kukonza SQL Server Agent kwa SQL Server 2014.
01 ya 06
Kuyambira SQL Server Agent mu SQL Server 2012
Tsegulani Manager Microsoft SQL Server Configuration Manager ndipo dinani pa "SQL Server Services" chinthu kumanzere. Ndiye, kumanja komweko, pezani utumiki wa SQL Server Agent. Ngati udindo wa utumikiwu ndi "NTCHITO", simukusowa kuchita chirichonse. Apo ayi, dinani pomwepa pa utumiki wa SQL Server Agent ndikusankha Yambani kuchokera kumasewera apamwamba. Ntchitoyo idzayamba kuyenda.
02 a 06
Pitani ku SQL Server Management Studio
Tsekani SQL Server Configuration Manager ndi lotsegula SQL Server Management Studio. Mu SSMS, yonjezerani fayilo ya Agulitsa SQL Server. Mudzawona mafolda ofutukulidwa omwe ali pamwambapa.
03 a 06
Pangani Job Agent Server Job
Kenaka, dinani pomwepa pa Folda ya Ntchito ndipo sankhani Ntchito Yatsopano kuchokera kumasewera oyambirira. Mudzawona zenera zatsopano zakulenga zowonetsedwa pamwambapa. Lembani malo a Dzina ndi dzina lapadera la ntchito yanu (kukhala akufotokozera kudzakuthandizani kuyendetsa bwino ntchito pamsewu!). Tchulani nkhani yomwe mukufuna kuti mukhale mwini wa ntchitoyi mu bokosi la mwiniwake. Ntchitoyi idzayenda ndi zilolezo za akauntiyi ndipo ingasinthidwe ndi mwiniwake kapena mamembala omwe ali ndi sysadmin.
Mukadatchula dzina ndi mwiniwake, sankhani chimodzi mwazinthu za ntchito zomwe mwazilembazo. Mwachitsanzo, mungasankhe gulu la "Maintenance Database" pa ntchito yosamalira nthawi zonse .
Gwiritsani ntchito gawo lalikulu lofotokozera malemba kuti mudziwe tsatanetsatane wa cholinga cha ntchito yanu. Lembani motere kuti wina (inu nokha mwaphatikizidwe) angathe kuyang'ana zaka zingapo kuchokera pano ndikukumvetsa cholinga cha ntchitoyi.
Potsirizira pake, onetsetsani kuti bokosi lovomerezeka lawunika.
Osati dinani Chabwino pakali pano - tili ndi zambiri zoti tichite pawindo ili!
04 ya 06
Onani Zotsatira za Ntchito
Kumanzere kwawindo la New Job, mudzawona chithunzi Chakutsogolera pansi pa "Sankhani tsamba". Dinani chizindikiro ichi kuti muwone kanthu kosalemba Job Step List yomwe ili pamwambapa.
05 ya 06
Pangani Ntchito Yoyeserera
Pambuyo pake, muyenera kuwonjezera zochitika payekha pa ntchito yanu. Dinani Bungwe Latsopano kuti mupange siteji yatsopano ndipo mudzawona New Job Step window yomwe ili pamwambapa.
A
Gwiritsani ntchito bokosi la malemba la Step Name kuti mupereke dzina lofotokozera la Khwerero.
Gwiritsani ntchito bokosi lakutsika lothandizira kuti musankhe malo omwe ntchitoyo idzachitapo.
Pomalizira, gwiritsani ntchito bokosi la Malamulo kuti mupereke syntax ya Transact-SQL yofanana ndi zomwe mukufunayo pa ntchitoyi. Mukamaliza kulowetsa, dinani batani la Parse kuti mutsimikizidwe mawu a syntax.
Pambuyo povomereza ndondomeko yake, dinani Kulungani kuti mupange sitepe. Bwerezani izi mobwerezabwereza ngati mukufunikira kuti mudziwe ntchito yanu ya SQL Server Agent.
06 ya 06
Sungani Aganyu anu a SQL Server 2012 Job
Potsiriza, mudzafuna kukhazikitsa ndondomeko ya ntchitoyo podutsa chithunzi cha Pulogalamuyo mu Sankhani Tsamba la Tsamba la New Job. Mudzawona zenera la ndondomeko yatsopano yowonetsedwa pamwambapa.
Perekani dzina la ndandanda mu Name Name box ndi kusankha mtundu wa pulogalamu (Nthawi imodzi, Kubwereza, Yambani pamene SQL Server Agent akuyamba kapena Yambani Pamene CPUs Ikhala Wosayera) kuchokera bokosi lakutsikira. Kenaka gwiritsani ntchito zigawo za nthawi ndizomwe pawindo kuti muwone magawo a ntchitoyo. Mukatsiriza dinani Kulungani kuti mutseke pazenera la Pulogalamuyo ndikukonza ntchito.