sp_delete_notification (T-SQL)

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'

See Also