Transact-SQL Reference
sp_delete_notification
Removes all notifications sent to a particular operator in response to an alert.
Syntax
sp_delete_notification [ @alert_name = ] 'alert' ,
[ @operator_name = ] 'operator'
Arguments
[@alert_name =] 'alert'
Is the name of the alert. alert is sysname, with no default.
[@operator_name =] 'operator'
Is the name of the operator. operator is sysname, with no default.
Return Code Values
0 (success) or 1 (failure)
Result Sets
None
Remarks
Removing a notification removes only the notification; the alert and the operator are left intact.
Permissions
Only members of the sysadmin fixed server role can execute sp_delete_notification.
Examples
This example removes all notifications sent to operator stevenb when alert 'Error 1101' occurs.
USE msdb
EXEC sp_delete_notification 'Error 11001', 'stevenb'