Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

Updates the notification method of an alert notification.


sp_update_notification [@alert_name =] 'alert',
[@operator_name =] 'operator',
[@notification_method =] notification


[@alert_name =] 'alert'

Is the name of the alert associated with this notification. alert is sysname, with no default.

[@operator_name =] 'operator'

Is the operator who will be notified when the alert occurs. operator is sysname, with no default.

[@notification_method =] notification

Is the method by which the operator is notified. notification is tinyint, with no default, and can be one or more of these values.

Value Description
1 E-mail
2 Pager
4 net send
7 All methods

Return Code Values

0 (success) or 1 (failure)


sp_update_notification must be run from the msdb database.

You can update a notification for an operator who does not have the necessary address information using the specified notification_method. If a failure occurs when sending an e-mail message or pager notification, the failure is reported in the SQL Server Agent error log.


Only members of the sysadmin fixed server role can execute sp_update_notification.


This example modifies the notification method for notifications sent to stevenb for the alert Test Alert.

USE msdb
EXEC sp_update_notification 'Test Alert', 'stevenb', 7

See Also




System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft