Izaziso ze-SQL Server Zinikeza Isaziso Sokuphutha Sokuzulazula
I-SQL Server Agent ivumela isaziso othomathikhi kubaphathi bezinqolobane uma izimo ezingavamile zenzeka. Le ndlela yokuqapha enamandla yenza ukuqapha kwamahora angu-24 ukusebenza kwedatha ngaphandle kokusebenza isikhungo sokusebenza samahora angu-24.
Isidingo Esijwayelekile sokuchaza isaziso
Ukuze uchaze uqaphile, udinga ulwazi oluthile oluyisisekelo olufaka:
- Igama lokwazisa - Amagama alert kumele abe ahlukile ku-SQL Server. Akwazike abe ngaphezu kwezinhlamvu ezingu-128.
- Umcimbi owenza uqaphile - Uhlobo lomcimbi lunikeza imingcele esetshenzisiwe. Lezi zinhlobo ezintathu zezixwayiso yizehlakalo ze-SQL Server, izimo zokusebenza ze-SQL Server kanye nemicimbi ye-Windows Management Instrumentation.
- Isenzo esenziwe yi-Agent SQL Server uma umcimbi ubangelwa. Noma yikuphi ukuphawula kungabelwa (noma kokubili) kwalezi zinhlobo ezimbili eziqaphile: Yenza umsebenzi we-Agent SQL Server kanye / noma Yazisa opharetha.
Isinyathelo-ngesinyathelo Isethaphu Sokuxwayisa SQL Server
Le miyalo isebenza ku-SQL Server 2005 nakamuva.
- Vula SQL Server Management Studio bese uxhuma kuseva yedatha lapho ufuna ukudala isaziso.
- Nweba ifolda ye-SQL Server Agent ngokuchofoza kanye ngesithonjana " + " ngakwesokunxele kwifolda.
- Chofoza ngakwesokudla kwifolda ye- Alerts bese ukhetha Isaziso Esisha kwimenyu e-pop-up.
- Thayipha igama elichazayo lesaziso sakho ebhokisini lombhalo.
- Khetha uhlobo lwesilingo kusuka kwimenyu ehlayo. Izinqumo zakho yizimo zokusebenza ze-SQL Server ezifana nokulayisha kwe-CPU nesikhala samahhala sediski, imicimbi ye-SQL Server njengamaphutha abulalayo, amaphutha we-syntax nezinkinga zehadiwe, nemicimbi ye-Windows Management Instrumentation (WMI).
- Nikeza noma yimiphi imininingwana ecacile yenkomba eceliwe yi-SQL Server njengombhalo othize kufakwe umbiko womcimbi kanye nemingcele yezixwayiso zesimo somsebenzi.
- Chofoza isithonjana sempendulo kuWebhu elisha le-Alert sika Khetha ikhasi lekhasi .
- Uma ufuna ukwenza umsebenzi we-Agent SQL Server uma uqaphile kwenzeka, chofoza ibhokisi lokuhlola lomsebenzi we- Execute bese ukhetha umsebenzi kwimenyu ehlayo.
- Uma ufuna ukwazisa opharetha be-database uma uqaphile kwenzeka, chofoza ibhokisi lokuhlola i- Notify bese ukhetha opharetha nezinhlobo zesaziso kusuka egridi.
- Chofoza OK ukudala isaziso.
Ukungeza izaziso ngokusebenzisa i-Transact-SQL
Kusukela nge-SQL Server 2008, ungabuye wengeze izaziso usebenzisa i-Transact-SQL. Sebenzisa le syntax kusuka ku-Microsoft:
sp_add_alert [@name =] [, [@message_id =] umyalezo_id] [, [@severity =] ubunzima], [@ [@enabled =] inikwe amandla],, @ @ @mail_message =] isaziso_message '] [, [@include_event_description_in =] include_event_description_in] [, [@database_name =]' database '] [, [@event_description_keyword =]' event_description_keyword_pattern '] [, {@ @ [obl =] = job_id | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] uphakamise_snmp_trap] [, [@performance_condition =] 'ukusebenza_condition'] [, [@category_name =] 'isigaba'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']