01 o te 06
Tīmatahia te Ratonga Agent SQL
Ka taea e te Agent Tūmau SQL te whakakore i te maha o nga mahi whakahaere. Ko tetahi o aua mahinga ko te whakamahi i te Agent Tūmau SQL hei waihanga me te whakarite i tetahi mahi e whakahaere aunoa i te whakahaere i te pātengi raraunga.
Whakatūwherahia te Kaiwhakahaere Whirihoranga Tūmau Microsoft SQL me te kimi i 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 Tūmau, ka tīpako Tīmata mai i te tahua pahū-ake hei whakatuwhera i te matapihi Ratonga Tīmata.
Tuhipoka : Ka hono tenei tuhinga ki te SQL Server 2008. Mena kei te whakamahi koe i tetahi putanga o SQL Server, ka hiahia koe ki te pānui i te Whakahaere i te Agent Tūmau SQL ki SQL Server 2012 .
02 o te 06
Whakatūwheratia te Kaiwhakahaere Whakahaere Tūmau SQL me te Whakawhānui i te Kōpaki Agent SQL Tūmau
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.
Tuhinga o mua
Waihanga he Kaiwhakahaere Tūmau SQL New Job
Pāwhiri-matau i te kōpaki Jobs me te whiriwhiri i te New Job mai i te tahua tīmatanga. Whakakīhia te ingoa Ingoa me tetahi ingoa ahurei mo to mahi (he whakaahuatanga ka awhina i a koe ki te whakahaere i nga mahi pai ake i te huarahi). Tauwhāitihia te pūkete e hiahia ana koe hei rangatira o 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.
I muri i to tohu i te ingoa me te rangatira, whiriwhiria tetahi o nga waahanga mahi kua tautuhia i te rārangi taka-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 te mahi. Tuhia i tetahi ara e taea ai e tetahi (i whakauru koe) 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 .
Tuhinga o mua
Whakauruhia te Matapihi Tautuhinga Hiko Ahuhu SQL
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 Huka Job.
Tuhinga o mua
Tāpirihia Ngā Arataki Hiko Ahuka SQL
Tāpirihia nga huarahi takitahi mo te mahi. Pāwhiritia te Paatene Hou hei waihanga i tetahi mahi mahi hou, ka kite koe i te matapihi New Job Step.
Whakamahia te pouaka kuputuhi Ingoa Tae 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 taahiraa mahi. I muri i to whakaoti i te waitohu, pawhiria te pene 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 te mahi Agent Server Tūmau e hiahiatia ana.
06 o 06
Whakaritehia te Job Agent Agent Job
Whakaritea he maatau 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 New . Ka kite koe i te matapihi New Job Job .
Whakaratohia he ingoa mo te waahi i te pouaka kuputuhi Ingoa me te whiriwhiri i te momo raupapa-Tuatahi-raa, Whakatika, Tīmata i te Tīmata o te Agent Tūmau SQL , te Tīmata rānei Ina riro nga PTM ki te Aukati-mai i te pouaka taka-iho. Whakamahia nga waahanga auau me nga waahanga o te matapihi hei tohu i nga tawhito o te mahi. Mena kua oti koe, kati OK hei kati i te matapihi Apiha me OK hei waihanga i te mahi.