Ko nga Aleruku Tūmau SQL Whakaratohia te Whakamatau Hapa-Rarangi-Clock
Ka taea e te Agent Tūmau SQL te tuku whakamōhio aunoa o nga kaiwhakahaere pātengi raraunga i te wa e puta ai nga āhuatanga rereke. Ko tenei mahinga mataara kaha e taea ai te aroturuki i te 24 haora mo te mahi paatai me te kore e whakahaere i te pokapū whakahaere 24-haora.
Mahinga Whānui mo te Tautuhi i te Alert
Hei tautuhi i te mataara, me hiahia koe ki etahi korero matua tae atu ki:
- Ingoa o te Alert - Me tuhi ahurei nga ingoa tohu ki te Tūmau SQL. Kaore e neke atu i te 128 nga tahua.
- Ko te kaupapa e tarai ana i te mataara - Ko te momo kaupapa e whakatau ana i nga tawhiri e whakamahia ana. Ko nga momo ngaohihi e toru he SQL Server, nga whakaritenga Mahi Tūmau SQL me nga Takahanga Whakahaere Whakahaere Windows.
- Ko te mahi a te Kaiwhakahaere Tūmau SQL i te wa e puta ai te kaupapa. Ka taea te tautuhi i tetahi mataaratanga (e rua ranei) o enei momo whakamataku: Whakaritehia te mahi Agent Tūmau SQL, me te / ranei Whakamōhiotia he kaiwhakahaere.
Haahi Tautuhinga Alert Tautuhinga Arataki-a -ahi
Ko enei tohutohu e whakamahi ana ki te SQL Server 2005 me te hou ake.
- Whakatūwheratia te Kaiwhakahaere Whakahaere Tūmau SQL me te hono atu ki te tūmau pātengi raraunga e hiahia ana koe ki te waihanga i te mataara.
- Whakarohahia te kōpaki Agent SQL Tūmau mā te pāwhiri kotahi i te " + " icon ki te taha mauī o te kōpaki.
- Pāwhiri-matau i te pouaka Alerts ka tīpako i te Alert Hou mai i te tahua pakū-ake.
- Patohia he ingoa whakaahua mo to mataara i roto i te pouaka kuputuhi Ingoa .
- Kōwhiria te momo o te mataara mai i te tahua taka-iho. Ko taau mahinga ko nga whakaritenga Mahi Tūmau SQL e rite ana ki te kawenga CPU me te mokowā mokowā noa, Ngā mahi Tūmau SQL pērā i te hapa kino, ngā hapa whakawhitinga, me ngā take pūmārō, me nga Takahanga Whakahaere Whakahaere Windows (WMI).
- Whakaratohia tetahi taipitopito motuhake e hiahiatia ana e te Tūmau SQL pēnei i te kuputuhi motuhake i roto i te ripoata me te taapiri mo nga whakaaturanga o te ahuatanga.
- Pāwhiritia te Whakautu Whakautu i te matapihi Alert New Tīpakohia he pihanga whārangi .
- Mena ka hiahia koe ki te mahi i te mahi Agent Tūmau SQL i te wa e puta mai ai te mataaratanga, pawhiria te pouaka Pouaka mahi me te whiriwhiri i te mahi mai i te tahua taka-iho.
- Ki te hiahia koe ki te whakamōhio i ngā kaiwhakarato pātengi raraunga ina puta mai te mataaratanga, pāwhiritia te pouaka tirotiro Whakatauranga whakamōhiotanga, ka tīpako i nga kaiwhakahaere me nga momo whakamōhiotanga mai i te tukutuku.
- Pāwhiritia OK hei waihanga i te mataara.
Te Whakauru i nga Alerts Ma te Mahi-SQL
Ka timata me te SQL Server 2008, ka taea hoki e koe te whakauru i nga whakamohiotanga ma te whakamahi i te Transact-SQL. Whakamahia tenei urutomo mai i Microsoft:
sp_add_alert [@name =] [, [@message_id =] message_id] [, [@severity =] kaha) [, [@enabled =] whakahohea] [, [@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 =] work_id | [@job_name =] 'name_name'}] [, [@raise_snmp_trap =] raise_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']