sp-update-notification-transact-sql.md

title	sp_update_notification (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_update_notification_TSQL sp_update_notification
dev_langs	TSQL
helpviewer_keywords	sp_updatenotification
ms.assetid	3e1c3d40-8c24-46ce-a68e-ce6c6a237fda
caps.latest.revision	19
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sp_update_notification (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Updates the notification method of an alert notification.

Transact-SQL Syntax Conventions

Syntax

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

Arguments

[ @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

Return Code Values

0 (success) or 1 (failure)

Remarks

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.

Permissions

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

Examples

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  

See Also

sp_add_notification (Transact-SQL)
sp_delete_notification (Transact-SQL)
sp_help_notification (Transact-SQL)
System Stored Procedures (Transact-SQL)