Skip to content

sp-add-notification-transact-sql.md

Latest commit

 

History

History
100 lines (70 loc) · 2.94 KB

sp-add-notification-transact-sql.md

File metadata and controls

100 lines (70 loc) · 2.94 KB
title sp_add_notification (Transact-SQL)
description Sets up a notification for an alert.
author MashaMSFT
ms.author mathoma
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_add_notification_TSQL
sp_add_notification
helpviewer_keywords
sp_add_notification
dev_langs
TSQL

sp_add_notification (Transact-SQL)

[!INCLUDE SQL Server]

Sets up a notification for an alert.

Syntax

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

Arguments

[ @alert_name = ] 'alert'

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

[ @operator_name = ] 'operator'

The operator to be notified when the alert occurs. @operator_name 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.

Value Description
1 E-mail
2 Pager
4 net send

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

sp_add_notification must be run from the msdb database.

[!INCLUDE ssManStudioFull] provides an easy, graphical way to manage the entire alerting system. Using [!INCLUDE ssManStudio] is the recommended way to configure your alert infrastructure.

To send a notification in response to an alert, you must first configure [!INCLUDE ssNoVersion] Agent to send mail.

If a failure occurs when sending an e-mail message or pager notification, the failure is reported in the [!INCLUDE ssNoVersion] Agent service error log.

Permissions

[!INCLUDE msdb-execute-permissions]

Examples

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

Note

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

USE msdb;
GO

EXECUTE dbo.sp_add_notification
    @alert_name = N'Test Alert',
    @operator_name = N'François Ajenstat',
    @notification_method = 1;
GO

Related content