Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_add_notification (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

Sets up a notification for an alert.

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

Topic link icon Transact-SQL Syntax Conventions

sp_add_notification [ @alert_name = ] 'alert' , 
    [ @operator_name = ] 'operator' , 
    [ @notification_method = ] notification_method

[ @alert_name = ] 'alert'

The alert for this notification. alert is sysname, with no default.

[ @operator_name = ] 'operator'

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

[ @notification_method = ] notification_method

The method by which the operator is notified. notification_method is tinyint, with no default. notification_method can be one or more of these values combined with an OR logical operator.








net send

0 (success) or 1 (failure)

sp_add_notification must be run from the msdb database.

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

To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.

If a failure occurs when sending an e-mail message or pager notification, the failure is reported in the SQL Server Agent service error log.

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

The following example adds an e-mail notification for the specified alert (Test Alert).


This example assumes that Test Alert already exists and that François Ajenstat is a valid operator name.

USE msdb ;

EXEC dbo.sp_add_notification
 @alert_name = N'Test Alert',
 @operator_name = N'François Ajenstat',
 @notification_method = 1 ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft