Funda indlela elula kakhulu yokwakha isaziso ngokusebenzisa i-SQL Server Agent

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:

Isinyathelo-ngesinyathelo Isethaphu Sokuxwayisa SQL Server

Le miyalo isebenza ku-SQL Server 2005 nakamuva.

  1. Vula SQL Server Management Studio bese uxhuma kuseva yedatha lapho ufuna ukudala isaziso.
  2. Nweba ifolda ye-SQL Server Agent ngokuchofoza kanye ngesithonjana " + " ngakwesokunxele kwifolda.
  3. Chofoza ngakwesokudla kwifolda ye- Alerts bese ukhetha Isaziso Esisha kwimenyu e-pop-up.
  4. Thayipha igama elichazayo lesaziso sakho ebhokisini lombhalo.
  5. 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).
  6. Nikeza noma yimiphi imininingwana ecacile yenkomba eceliwe yi-SQL Server njengombhalo othize kufakwe umbiko womcimbi kanye nemingcele yezixwayiso zesimo somsebenzi.
  7. Chofoza isithonjana sempendulo kuWebhu elisha le-Alert sika Khetha ikhasi lekhasi .
  8. Uma ufuna ukwenza umsebenzi we-Agent SQL Server uma uqaphile kwenzeka, chofoza ibhokisi lokuhlola lomsebenzi we- Execute bese ukhetha umsebenzi kwimenyu ehlayo.
  9. Uma ufuna ukwazisa opharetha be-database uma uqaphile kwenzeka, chofoza ibhokisi lokuhlola i- Notify bese ukhetha opharetha nezinhlobo zesaziso kusuka egridi.
  1. 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 ']