Funda indlela elula kakhulu yokwakha i-Alert usebenzisa i-SQL Server Agent

Izaziso zeSQL Server Izaziso Zinikezela ngezaziso ze-Round-clock-Clock

Ummeli we-SQL Server uvumela isaziso ngokuzenzekelayo kubaphathi beenkcukacha xa iimeko ezingaqhelekanga zenzeka. Le ndlela yokulumkisa enamandla yenza ukuba kubekwe iliso lama-24 kwindlela yokusebenza kwedatha ngaphandle kokusebenza kwesikhungo sokusebenza kweeyure ezingama-24.

IsiGaba esiPhezulu sokuSichaza iSaziso

Ukuze uchaze isilumkiso, udinga ulwazi olusisiseko olubandakanya:

• Igama lokwazisa - Izaziso zamagama mazibe zodwa kwiSQL Server. Akunakubakho ngaphezu kweebhali ezili-128.
• Isiganeko esibangela ukulumkisa - Uhlobo lwesiganeko lunquma iiparameters ezisetyenzisiweyo. Ezi zintathu iintlobo zezilumkiso zizeziganeko zeSQL Server, iimeko zeSQL Server kunye neziganeko ze-Windows Management Instrumentation.
• Isenzo esenziwa yi-Agent SQL Server xa kwenzeka isiganeko. Naluphina isilumkiso sinokwabelwa (okanye zombini) kwezi ntlobo ezimbini ezilumkileyo: Yenza umsebenzi we-SQL Server Agent kunye / okanye Yazisa umsebenzisi.

I-Step-by-Step-Step-Step-Step Alert Setup

Le miyalelo isebenza kwi-SQL Server 2005 nakutsha.

1. Vula i- SQL Server Management Studio kwaye udibanise kumncedisi wesiseko apho ufuna ukudala isilumkiso.
2. Ukwandisa ifolda yommeli we-SQL Server ngokuchofoza kanye kwi icon " + " ngakwesobunxele kwifolda.
3. Ukucofa kwesokudla kwiifayile zeAlva uze ukhethe iNew Alert kwimenyu ephumayo.
4. Thayipha igama elichazayo malunga nesilumkiso sakho kwibhokisi legama legama .
5. Khetha uhlobo lwesilumkiso kwimenyu ehlayo. Izigqibo zakho ziimeko zokusebenza ze-SQL Server ezifana nomthwalo we-CPU kunye nesithuba sediski samahhala, iziganeko zeSQL Server ezifana neziphene ezibulalayo, iimpazamo ze-syntax kunye ne-hardware, kunye ne-Windows Management Instrumentation (WMI).
6. Ukubonelela nayiphi na iinkcukacha ezicacileyo zokulinda eziceliwe ngu-SQL Server ezifana nesicatshulwa esithile esifakwe kwingxelo yesiganeko kunye nemigqaliselo yokwenza izixwayiso zesimo.
7. Chofoza uphawu lwempendulo kwiwindow entsha ye-Alert Khetha ikhefu lephepha .
8. Ukuba ufuna ukuphumeza umsebenzi we-SQL Server Agent xa uqaphile kwenzeka, qhosha iqhosha lokukhangela lomsebenzi kwaye ukhethe umsebenzi kwimenyu ehlayo.
9. Ukuba ufuna ukwazisa abaqhubi benethiwekhi xa uqaphile kwenzeka, cofa kwiBhokisi yazisa abaqhubi uze ukhethe abaqhubi kunye neentlobo zesaziso ukusuka kwigridi.

1. Cofa u- OK ukwenza isilumkiso.

Ukongeza iAlers Using Transact-SQL

Ukuqala nge-SQL Server 2008, unokongeza izaziso usebenzisa iTransact-SQL. Sebenzisa le syntax kwiMicrosoft:

sp_add_alert [@name =] [, [@message_id =] message_id] [, [@severity =] ubunzima] [, [@enabled =] inikwe amandla], [, [@delay_between_responses =] ukulibazisa_between_responses] [, [@notification_message =] ' isaziso_message '] [, [@include_event_description_in =] iquka_event_description_in] [, [@database_name =]' database '] [, [@event_description_keyword =]' event_description_keyword_pattern '] [, {@ @obb_id =] job_id | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] uphakamise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'isigaba'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']