Phunzirani Njira Yosavuta Yopanga Alert Pogwiritsa ntchito SQL Server Agent

SQL Server Zachenjeza Kupereka Chidziwitso Chopotoza Chakuzungulira

SQL Server Agent amalola kudziwitsidwa kokha kwa adiresi akuluakulu pamene zochitika zachilendo zimachitika. Njira yowonetsera mphamvuyi imapangitsa kuti maola 24 apitirize kufufuza ntchito popanda kugwiritsa ntchito malo ochitira maola 24.

Zofunika Zambiri pa Kufotokozera Chenjezo

Pofuna kufotokoza tcheru, muyenera kudziwa mfundo zofunika monga:

• Dzina lachenjezo - Mayina a Alert ayenera kukhala osiyana mu SQL Server. Iwo sangakhale oposa malemba 128.
• Chochitika chomwe chimayambitsa chisamaliro - Mtundu wa zochitika zimapanga magawo omwe amagwiritsidwa ntchito. Mitundu itatu ya machenjezo ndizochitika SQL Server, zochitika za SQL Server ndi zochitika za Windows Management Instrumentation.
• Chochita chimene SQL Server Agent amatenga pamene chochitikacho chikuyambitsa. Wochenjeza aliyense angathe kupatsidwa (kapena onse) a mitundu iwiri yochenjeza: Chitani ntchito ya SQL Server Agent ndi / kapena Adziwitse wothandizira.

Wokambirana ndi SQL Server Alert Setup

Malangizo awa amagwiritsidwa ntchito ku SQL Server 2005 ndi atsopano.

1. Tsegulani SQL Server Management Studio ndikugwiritsira ntchito seva yachinsinsi komwe mukufuna kukhazikitsa tcheru.
2. Lonjezani foda yamagulu a SQL Server potsegula kamodzi pa chithunzi " + " kumanzere kwa foda.
3. Dinani pomwepa pa fayilo za Alerts ndikusankha Watsopano Alert kuchokera pop-up menu.
4. Lembani dzina lodziŵitsa kuti mukhale tcheru mu Dzina la bokosi.
5. Sankhani mtundu wa tcheru kuchokera ku menyu otsika. Zosankha zanu ndizochitika za SQL Server monga CPU katundu ndi disi ya disk space, zochitika za SQL Server monga zolakwa zakupha, zolakwika za syntax ndi nkhani za hardware, ndi zochitika za Windows Management Instrumentation (WMI).
6. Perekani chilichonse chodziwitsidwa ndi SQL Server monga malemba omwe akuphatikizidwa mu lipoti lazochitika ndi magawo a zidziwitso za chikhalidwe.
7. Dinani chizindikiro cha Mayankho muwindo la Alert Latsopano la Sankhani tsamba pamanja.
8. Ngati mukufuna kuchita ntchito ya Aganyu la SQL Server pamene chenjezo likuchitika, dinani ntchito yolemba ntchito ya Execute ndikusankha ntchito ku menyu yoyipa.
9. Ngati mukufuna kuzindikiritsa ogwira ntchito osungirako deta nthawi yomwe tcheru likuchitika, dinani kabokosi lozindikiritsa olemba ntchitoyo ndikusankha ogwira ntchito ndi mitundu yozindikiritsa kuchokera ku gridi.

1. Dinani OK kuti mukhale tcheru.

Kuwonjezera Malangizo Pogwiritsa Ntchito Transact-SQL

Kuyambira ndi SQL Server 2008, mukhoza kuwonjezera machenjezo pogwiritsa ntchito Transact-SQL. Gwiritsani ntchito syntax iyi ku Microsoft:

sp_add_alert [@message_id =] message_id] [, [@severity =] kuuma] [, [@enabled =] enabled] [, [@delay_between_responses =] delay_between_responses],, @ @tification_message =] ' notification_message '] [, [@include_event_description_in =] include_event_description_in] [, [@database_name =]' database '] [, [@event_description_keyword =]' event_description_keyword_pattern '] [, {[@job_id =] job_id | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] raise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'gulu'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']