sp_updatenotification SQL Executive Stored Procedure

Updates the notification method of an alert notification.

Syntax

sp_updatenotification alert_name, operator_name, notification_method

where

alert_name

Is the name of the alert associated with this notification.

operator_name

Specifies which operator will be notified when the alert occurs.

notification_method

Indicates the method by which the operator will be notified. Can be: EMAIL, PAGER, or BOTH.

Remarks

This stored procedure must be run from the msdb database.

You can update a notification for an operator who does not have the necessary address information to be notified using the specified notification_method. If a failure occurs when sending an e-mail message or pager notification, the failure is reported in the Windows NT application event log.

SQL Enterprise Manager provides an easy, graphical way to manage the entire alerting system. Using SQL Enterprise Manager is the recommended way to configure your alert infrastructure.

Example

This example sets the notification status to EMAIL.

sp_updatenotification 'Test Alert', 'John Doe', EMAIL

Permission

Only the system administrator can use this procedure.

Tables Used

sysalerts, sysnotifications, sysoperators

See Also