Dzidza Nzira Inonyanya Kuita Yokugadzira Alert Using SQL Server Agent

SQL Server Alerts Inopa Hurukuro-ye-Clock Error Notification

SQL Server Agent inobvumira zvakananga chiziviso chevashandi vepa database kana zvisingawanzoitika mamiriro ezvinhu. Iyi nzira yakasimba yekuchenjerera inoita kuti maawa makumi maviri nemasere ekuongororwa kwebhuku rekushanda ishande pasina kushanda kwemaawa makumi maviri nemasere.

Gwaro Rinodikanwa Rokufananidzira Nzwisiso

Kuti urondedze kuchenjerera, unoda mamwe mashoko ekutanga anosanganisira:

• Zita rekucherechedza - Alert mazita anofanira kunge akasiyana mune SQL Server. Vanogona kunge vasisipo kudarika mazita 128.
• Chiitiko chinokonzera kuchenjerera - Chiitiko chechiitiko chinogadzirisa matanho anoshandiswa. Iyo mitatu yezviyeuchidzo ndeyezviitiko zveSQL Server, SQL Server maitiro uye Windows Management Instrumentation zviitiko.
• Chiito icho SQL Server Agent inotora apo chiitiko chacho chinotanga. Chero chengwariro inogona kugoverwa (kana maviri) yemhando mbiri idzi dzakangwara: Ita basa reSQL Server Agent uye / kana Zivisai anoshanda.

Nhanho-Nhanho SQL Server Alert Setup

Iyi mirayiridzo inoshanda kuSQL Server 2005 uye itsva.

1. Vhura SQL Server Management Studio uye taurira hovha ye database uko iwe unoda kuumba maziso.
2. Wedzera faira yeSquL Server Agent nekunyanya kamwe pane " + " icon kuruboshwe rwefolda.
3. Kungofa paIndaneti faira uye sarudza New Alert kubva kumapop up menu.
4. Tora zita rinotsanangurwa kuti rive rakangwara muZita text box.
5. Sarudza rudzi rwekucherechedza kubva kumenyu yakaderera. Zvisarudzo zvako ndezviSQL Server zvinoshanda maitiro akadai seC CPU load uye isina nzvimbo disk, zviitiko zveSQL Server zvakadai sezvikanganiso zvinouraya, zvikanganiso zvema syntax uye nyaya dzehurumende, uye zviitiko zveWindows Management Instrumentation (WMI).
6. Gadzirira chero zvakanyatsotsvaga zvakatsvaga zvakakumbirwa naSQL Server zvakadai semashoko akanyorwa mubhuku remuitiko uye zvidimbu zvekushanda kwemamiriro emamiriro ezvinhu.
7. Dzvanya pikicha yekupindura muNew Alert hwindo reSarudza peji pane.
8. Kana iwe uchida kuita SQL Server Agent basa apo maziso aripo, chengetedza basa re Execute basa checkbox uye sarudza basa kubva pakaderera pasi.
9. Kana iwe uchida kuzivisa vafambisi vepa database apo maziso akaitika, chengetai maNotify operators check box uye musarudze vafambisi uye mapeji ekuzivisa kubva gridhi.

1. Dzvanya OK kuti ugadzire kuchenjerera.

Kuwedzera Alerts Using Transact-SQL

Kutanga neSQL Server 2008, unogonawo kuwedzera zvayese kushandisa Transact-SQL. Shandisa iyi syntax kubva kuMicrosoft:

sp_add_alert [@message_id =] message_id] [, [@severity =] dambudziko] [, [@enabled =] enabled] [, [@delay_between_responses =] delay_between_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 | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] lift_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']