Alerts na SQL Server Samar da Bayanin Kuskuren Buga-Clock-Clock
Asusun SQL Server yana bada izini na atomatik na masu amfani da bayanai lokacin da yanayi ya faru. Wannan makirci mai tsabta yana sa ido ga sauti 24 na aikin data ba tare da yin aiki na tsakiya na 24 hours ba.
Janar da ake buƙata don bayyana fassarar
Domin ƙayyade wani faɗakarwa, kuna buƙatar wasu bayanai na asali ciki har da:
- Sunan Alert - Sunan alamun suna zama na musamman a SQL Server. Suna iya zama fiye da haruffa 128.
- Abinda ya haifar da faɗakarwa - Nau'in taron ya ƙayyade sassan da aka yi amfani dasu. Nau'ikan iri uku na faɗakarwa sune abubuwan SQL Server, ka'idodi na SQL Server da kuma Windows Management Instrumentation events.
- Ayyukan da SQL Server Agent dauka lokacin da abin ya faru ne. Duk wani faɗakarwa za a iya sanya ko dai (ko duka biyu) na wadannan nau'i-nau'i guda biyu: Kashe aiki na SQL Server Agent da / ko Sanarwa wani mai aiki.
Shigar da Shirye-shiryen Alert ɗin Sabis na Mataki na Mataki
Wadannan umarnin sun shafi SQL Server 2005 da sababbin.
- Bude SQL Server Management Studio da kuma haɗa zuwa uwar garken database inda kake son ƙirƙirar faɗakarwa.
- Ƙara fadada babban fayil na SQL Server ta danna sau ɗaya a kan " + " icon a hagu na babban fayil.
- Danna-dama a babban fayil ɗin Faɗakarwa kuma zaɓi Sabon Alert daga menu na pop-up.
- Rubuta sunan da aka kwatanta don faɗakarwa a cikin akwatin rubutu na Rubutun.
- Zaɓi nau'in faɗakarwa daga menu mai saukewa. Zaɓinku su ne ka'idodi na SQL Server kamar caca CPU da sararin sarari, abubuwan SQL Server kamar su kurakurai fatal, kurakuran kurakurai da matsala, da abubuwan Windows Management Instrumentation (WMI).
- Samar da duk wani bayani na tsararraki da aka buƙata ta SQL Server kamar rubutu mai mahimmanci da aka haɗa a cikin rahoton rahoto da sigogi don faɗakarwa na yanayin aiki.
- Danna maɓallin amsawa a cikin sabon Alert taga ta Zaɓi wani adireshin shafi .
- Idan kana so ka aiwatar da aikin SQL Server Agent lokacin da faɗakarwa ta auku, danna akwatin aiki na Ƙaddamar da aiki kuma zaɓi aikin daga menu mai saukewa.
- Idan kana so ka sanar da masu amfani da layi lokacin da faɗakarwar ta auku, danna akwatin dubawa masu aiki kuma sannan ka zaɓi masu aiki da sanarwar wasu daga grid.
- Danna Ya yi don ƙirƙirar faɗakarwa.
Karin Ƙararraki Ta Amfani da Transact-SQL
Da farko tare da SQL Server 2008, zaka iya ƙara faɗakarwa ta amfani da Transact-SQL. Yi amfani da wannan haɗin daga Microsoft:
sp_add_alert [@name =] [, [@message_id =] message_id] [, [@severity =] tsananin] [, [@enabled =] kunna] [, [@delay_between_responses =] jinkirta tsakanin_responses] [, [@notification_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 | [, [@raise_snmp_trap =] raise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']