01 ya 06
Yambani Utumiki Wothandizira SQL Server
Wothandizira SQL Server amakulolani kuti muzitha kugwira ntchito zosiyanasiyana. Imodzi mwa ntchitozi ikuphatikizapo kugwiritsa ntchito SQL Server Agent kukhazikitsa ndikukonzekera ntchito yomwe ikupanga kasamalidwe ka deta.
Tsegulani Oyang'anira Microsoft SQL Server Configuration Manager ndi kupeza SQL Server Agent utumiki. Ngati udindo wa pulogalamuyo ndi "NTCHITO," simusowa kuchita chirichonse. Popanda kutero, dinani pomwepa pa utumiki wa SQL Server Agent ndikusankha Yambani kuchokera kumasewera apamwamba kuti mutsegule tsamba loyamba la utumiki.
Zindikirani : Nkhaniyi ikugwiritsidwa ntchito ku SQL Server 2008. Ngati mukugwiritsa ntchito SQL Server yotsatira, mukhoza kuwerenga Kukonza SQL Server Agent mu SQL Server 2012 .
02 a 06
Tsegulani SQL Server Management Studio ndi Kuwonjezera SQL Server Agent Folder
Tsekani SQL Server Configuration Manager ndi lotsegula SQL Server Management Studio. Mu SSMS, yonjezerani fayilo ya Agulitsa SQL Server.
03 a 06
Pangani Job New Agent Job Job
Dinani pakanema pa Jobs folder ndikusankha Job Watsopano kuchokera mndandanda-up menu. Lembani dzina lachidziwitso ndi dzina lapaderalo la ntchito yanu (kukhala akufotokozera kudzakuthandizani kuyendetsa bwino ntchito mumsewu). Tchulani nkhani yomwe mukufuna kukhala mwini wa ntchitoyi mu bokosi la mwiniwake . Ntchitoyi idzayenda ndi zilolezo za akauntiyi ndipo ingasinthidwe ndi mwiniwake kapena mamembala omwe ali ndi sysadmin.
Mutatha kufotokoza dzina ndi mwiniwake, sankhani chimodzi mwazinthu zomwe mwazikonzekera kuchokera pazomwe mukulemba. Mwachitsanzo, mungasankhe gulu la "Maintenance Database" pa ntchito yosamalira nthawi zonse.
Gwiritsani ntchito gawo lalikulu lofotokozera malemba kuti mudziwe tsatanetsatane wa cholinga cha ntchitoyi. Lembani motere kuti wina (inu nokha) mukhoze kuyang'ana zaka zingapo kuchokera pano ndikukumvetsa cholinga cha ntchitoyi.
Potsirizira pake, onetsetsani kuti bokosi lovomerezeka lawunika .
04 ya 06
Lowetsani Wofalitsa wa SQL Server Job Job Screen
Kumanzere kwawindo la New Job , mudzawona chithunzi Chakutsogolera pansi pa "Sankhani tsamba". Dinani chizindikiro ichi kuti muwone kanthu kosalemba Job Step List.
05 ya 06
Onjezerani Wofalitsa wa SQL Server Job Job Steps
Onjezerani masitepe apadera pa ntchitoyo. Dinani Bungwe Latsopano kuti mupange sitepe yatsopano ndipo mudzawona New Job Step window.
Gwiritsani ntchito Name Name ndime bokosi kuti mupereke dzina lofotokozera la Khwerero.
Gwiritsani ntchito bokosi lakutsika lothandizira kuti musankhe malo omwe ntchitoyo idzachitapo.
Potsiriza, gwiritsani ntchito bokosi la Malamulo kuti mupereke syntax ya Transact-SQL yofanana ndi zomwe mukufunayo pa ntchitoyi. Mukadzatsiriza kulowa mu lamuloli, dinani batani la Parse kuti mutsimikizidwe mawu a syntax.
Pambuyo povomereza ndondomeko yake, dinani Kulungani kuti mupange sitepe. Bweretsani njirayi nthawi zambiri ngati mukufunikira kuti mudziwe ntchito yoyenera ya Aganyu SQL Server.
06 ya 06
Sungani Wopanga SQL Server Job
Konzani ndondomeko ya ntchito podutsa pulogalamu ya Pulogalamuyo mu Sankhani Tsamba la Tsamba la New Job . Mudzawona zenera la Ndondomeko Yatsopano ya Ntchito .
Perekani dzina la ndandanda mu Name Name box ndi kusankha mtundu wa ndondomeko-Nthawi imodzi, Yowonjezeranso, Yambani pamene SQL Server Agent Yayamba kapena Yambani Pamene CPU Ikhala Wosayera-kuchokera ku bokosi lakutsikira. Gwiritsani ntchito zigawo zafupipafupi ndi zowonjezera pazenera kuti muwone magawo a ntchitoyo. Mukadzatsiriza, dinani OK kuti mutsegule zenera ndikulumikiza .