Aoao le Auala E Sili Ona Fai e Fausia ai se Alesi Faʻaaogaina le Agent Satisite SQL

Faʻasalalauga Faʻasalalau SQL Faʻasaʻoina le Faʻailoaina o le Faʻasalaga Taʻiala-Clock-Clock

E mafai e le Agent Satisite SQL ona faʻaalia vave le faʻalauiloaina o pulefaʻatasiga faʻamaumauga pe a tutupu ni tulaga le masani. O lenei masini mataala eletise e mafai ai ona mataituina le 24 itula i le faʻatinoina o faʻamaumauga e aunoa ma le faʻaaogaina o le 24-itula operation center.

Tulaga Lautele mo le Faʻamatalagaina o se Ale

I le faʻamalamalamaina o le mataalia, e te manaʻomia ni faʻamatalaga masani e aofia ai:

• Igoa o le Alert - O igoa Alert e tatau ona tulaga ese i le SQL Server. E le sili atu nai lo le 128 igoa.
• O le mea na tupu e faʻamaonia ai - O le mea e fai ai mea e fuafuaina ai le faʻaaogaina o mea e faʻaaogaina. O ituaiga e tolu o faʻasalalauga o faʻamaumauga a le SQL Server, faʻatulagaga o le Tūlagamau SQL ma faʻalapotopotoga o le Faʻasalalauga o le Windows.
• Le gaioiga a le Agent Server Tūmau e ave pe a tupu le mea na tupu. Soʻo se mataala e mafai ona tuʻuina atu (poʻo mea uma e lua) o nei uiga mataala e lua: Ave se galuega a le Agelu SQL Server ma / poʻo le Notify se operator.

Seti taʻitasi i le Laasaga Seti o Alert Server

O nei faatonuga e faʻaaoga i le SQL Server 2005 ma fou atu.

1. Tatala le SQL Server Management Studio ma faʻafesoʻotaʻi i le 'upega tafaʻilagi le mea e te manaʻo ai e fai se mataala.
2. Faʻateleina le faila Agent Server Siiu i le tasi i luga o le " + " icon i le itu tauagavale o le faila.
3. Faʻasani-saʻo i luga o le Alerts folder ma filifili Avanoa Fou mai le lisi o mea pop-up.
4. Taʻu se igoa faʻamatalaga mo lau mataala i le pusa o le Tusiga igoa .
5. Filifili le ituaiga o mataala mai le lisi o le pa'ū. O au filifiliga o faʻatulagaga o le Tūmau SQL o loʻo pei o le utaina o le CPU ma le avanoa vaʻavaʻai saoloto, faʻamaumauga SQL Server e pei o mea leaga, sese faʻamaonia ma mea faʻapitoa, ma mea e tutupu i le Windows Management Instrumentation (WMI).
6. Tuuina atu ni faʻamatalaga mataʻituina na talosagaina e le SQL Server e pei o faʻamaumauga patino o aofia ai i le lipoti o faʻasologa ma faʻamaumauga mo le faʻaalia o faʻamatalaga o tulaga.
7. Kiliki le Tali i le New Alert window Filifili se faʻailoga o le itulau .
8. Afai e te manaʻo e faʻatino se galuega a le Agent SQL Tūmau pe a tulai mai le mataala, kiliki le Boxbox jobboxbox ma filifili se galuega mai le lisi o le pa'ū.
9. Afai e te manaʻo e faʻamatalaga le 'auʻaunaga faʻamatalaga pe a tulaʻi mai le mataala, kiliki i le Notify operators box and then select the operator and types of notification from the grid.

1. Kiliki le OK e fatu le mataala.

Faʻaopoopoina Alerts Faaaoga Faʻatauga-SQL

Amata i le SQL Server 2008, e mafai foi ona e faaopoopo faʻamalo e faʻaaoga ai le Transact-SQL. Faʻaoga lenei faʻailoga mai Microsoft:

"[[@name_id]] message_id] [, [@message_id =] message_id] [, [@severity =] malosi] [, [@enabled =] mafai] [, [@delay_between_responses =] delay_between_responses] [, [@notification_message =] ' "[event_description_keyword_pattern '] [, [@ [ausa_event_description_in] [, [@database_name =]' database '] [, [@event_description_keyword =]' event_description_keyword_pattern '] [, [{@job_id =] job_id | [, [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] raise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']