Section courante

A propos

Section administrative du site

sp_update_alert

Alerte mise à jour
SQL Server

Syntaxe

sp_update_alert
[ @name =] 'name'
[ , [ @new_name =] 'new_name']
[ , [ @enabled =] enabled]
[ , [ @message_id =] message_id]
[ , [ @severity =] severity]
[ , [ @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']
[ , [ @job_id =] job_id | [@job_name =] 'job_name']
[ , [ @occurrence_count = ] occurrence_count]
[ , [ @count_reset_date =] count_reset_date]
[ , [ @count_reset_time =] count_reset_time]
[ , [ @last_occurrence_date =] last_occurrence_date]
[ , [ @last_occurrence_time =] last_occurrence_time]
[ , [ @last_response_date =] last_response_date]
[ , [ @last_response_time =] last_response _time]
[ , [ @raise_snmp_trap =] raise_snmp_trap]
[ , [ @performance_condition =] 'performance_condition' ]
[ , [ @category_name =] 'category']
[ , [ @wmi_namespace = ] 'wmi_namespace' ]
[ , [ @wmi_query = ] 'wmi_query' ]

Description

Cette Stored Procedure permet de mettre à jour les paramètres d'une alerte existante.



Dernière mise à jour : Dimanche, le 29 Août 2021