Ka taea e te Agent Tūmau SQL te whakakore i te maha o nga mahi whakahaere. I roto i tenei akoranga, ka haere tatou i roto i te tukanga o te whakamahi i te Agent Tūmau SQL ki te waihanga me te whakarite i tetahi mahi e whakahaere aunoa i te whakahaere raraunga. He mea motuhake tenei akoranga ki te SQL Server 2012 . Mena kei te whakamahi koe i te putanga o SQL Server i mua atu, ka hiahia pea koe ki te tairongo i te Whakahaere Raraunga Umanga me te Agent Tūmau SQL . Mena kei te whakamahi koe i tetahi putanga o SQL Server, ka hiahia pea koe ki te pānui i te Whakahaere i te Agent Tūmau SQL mō te Tūmau SQL 2014.
01 o te 06
Tīmata i te Kaiwhakahaere Tūmau SQL i te Tūmau SQL 2012
Whakatūwherahia te Kaiwhakahaere Whirihoranga Tūmau Microsoft SQL me te pāwhiri i te "Tūmau SQL Server" i roto i te pihanga maui. Na, i roto i te pihanga tika, kimihia te ratonga Agent SQL Server. Mena te mana o taua ratonga "RUNNING", kaore koe e hiahia ki te mahi i tetahi mea. Ki te kore, ka pawhiri-matau ki te ratonga Agent SQL Server ka tīpako Tīmata i te tahua pahū-ake. Ka timata te ratonga.
02 o te 06
Whakawhiti ki te Whakahaere Whakahaere Tūmau SQL
Katia te Kaiwhakahaere Whirihoranga Tūmau SQL me te whakatuwhera i te Whakahaere Whakahaere Tūmau SQL. I roto i te SSMS, whakawhānui i te kōpaki Agent SQL Server. Ka kite koe i nga pouaka kua whakawhānui kua whakaaturia i runga.
Tuhinga o mua
Waihangahia he Job Agent Agent Job
I muri mai, pawhiri-matau i te waahanga Mahi ka tohua a New Job mai i te tahua timatanga-ake. Ka kite koe i te matapihi o te hanganga New Job kua whakaaturia i runga nei. Whakakīahia te ingoa Ingoa me tetahi ingoa motuhake mo to mahi (ko te whakaahuatanga ka awhina i a koe ki te whakahaere i nga mahi pai ake i te ara!). Whakaritea te taakete e hiahia ana koe hei rangatira mo te mahi i roto i te pouaka kuputuhi Kaihanga. Ka whakahaerehia te mahi me nga whakaaetanga o tenei kaute, ka taea anake te whakarereketia e te rangatira me nga mema o te mahi sysadmin.
Kia oti kua tohua e koe te ingoa me te rangatira, whiriwhiria tetahi o nga waahanga mahi kua tautuhia i te rārangi heke-iho. Hei tauira, ka taea e koe te whiriwhiri i te waahanga "Tautuhinga Whakahaere Raraunga" mo nga mahi tiaki mahi .
Whakamahia te mahinga kuputuhi Whakaaturanga nui hei whakarato i te whakaahua taipitopito o te kaupapa o to mahi. Tuhia i tetahi ara e taea ai e tetahi (me whakauru koe!) Ki te titiro ki a ia i etahi tau mai i tenei wa ka mohio ki te kaupapa o te mahi.
Hei whakamutunga, me whakarite kia tirohia te pouaka Whakaahei.
Kaua e pāwhiri OK noa tonu - he nui ake ta tatou mahi i tenei matapihi!
Tuhinga o mua
Tirohia nga Hipanga Job
I te taha maui o te matapihi New Job, ka kite koe i tetahi Hipanga icon i raro i te "Tīpakohia he whārangi" pane. Pawhiria tenei ataata kia kite i te Rarangi Hipanga Job e whakaaturia ana i runga.
Tuhinga o mua
Waihangahia he Hipanga Job
Muri iho, me hiahia koe ki te tapiri i nga huarahi takitahi mo to mahi. Pāwhiritia te Paatene Hou hei waihanga i tetahi mahi mahi hou, ka kite koe i te matapihi Hipanga New Job i whakaaturia i runga.
Whakamahia te pouaka kuputuhi Ingoa Tautuhi hei whakarato i tetahi ingoa whakaahua mo te Hipanga.
Whakamahia te pouaka taka-iho Raraunga hei whiriwhiri i te pātengi raraunga e mahi ai te mahi.
Hei whakamutunga, whakamahia te pouaka kuputuhi whakahau kia whakaratohia te raupapa Transact-SQL ki te mahi e hiahiatia ana mo tenei mahi. Kia oti ia koe te whakauru ki te whakahau, pawhiria te paatene Parse hei whakauru i te raupapa.
I muri i te whaimana o te whakaahinga, pāwhiritia OK hei waihanga i te taahiraa. Whakahokia tenei tukanga kia maha nga wa e tika ana hei tautuhi i to mahi Agent Tūmau SQL e hiahiatia ana.
06 o 06
Whakaritehia to Agent Tūmau SQL 2012 Job
Hei whakamutunga, ka hiahia koe ki te whakatakoto i tetahi waarangi mo te mahi ma te panui i te hiko o te Apiti i roto i te Tīpakohia he waahanga Whārangi o te matapihi Job hou. Ka kite koe i te whakaaturanga Hōtaka Huka Hōu i whakaaturia i runga nei.
Whakaratohia he ingoa mo te waarangi i te pouaka kuputuhi Ingoa me te whiriwhiri i te momo raupapa (Te kotahi-wa, te whakahou, te Tīmata ka timata te Agent Tūmau SQL, te Tīmata rānei ina Nga Piihi Kaeke) mai i te pouaka taka-iho. Na ka whakamahi i nga waahanga me nga wa roa o te matapihi hei tohu i nga tawhito o te mahi. Ina mutu koe ka pawhiria te OK kia kati i te matapihi Apiha me OK hei waihanga i te mahi.