Sets up a notification for an alert.
- [ @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.
sp_add_notification must be run from the msdb database.
Microsoft SQL Server Management Studio provides an easy, graphical way to manage the entire alerting system. Using SQL Server 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. For more information, see SQL Server Agent 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.
The following example adds an e-mail notification for the specified alert (
This example assumes that |
USE msdb ; GO EXEC dbo.sp_add_notification @alert_name = N'Test Alert', @operator_name = N'François Ajenstat', @notification_method = 1 ; GO