Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

sp_update_notification (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Updates the notification method of an alert notification.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

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

[ @alert_name =] 'alert'

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

[ @operator_name =] 'operator'

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

[ @notification_method =] notification

The method by which the operator is notified. notificationis 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

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 Microsoft SQL Server Agent error log.

To run this stored procedure, users must be granted the sysadmin fixed server role.

The following example modifies the notification method for notifications sent to François Ajenstatfor the alert Test Alert.

USE msdb ;
GO

EXEC dbo.sp_update_notification
   @alert_name = N'Test Alert',
   @operator_name = N'François Ajenstat',
   @notification_method = 7;
GO

Community Additions

ADD
Show:
© 2015 Microsoft