sp_dropnotification SQL Executive Stored Procedure

Drops a notification for an alert.

Syntax

sp_dropnotification alert_name, operator_name

where

alert_name

Specifies the alert to drop the notification for.

operator_name

Is the name of the operator who is no longer to be notified when alert_name occurs.

Remarks

This stored procedure must be run from the msdb database.

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

Example

This example drops the notification information for the 'Test Alert' alert.

sp_dropnotification 'Test Alert', 'John Doe'

Permission

Only the system administrator can use this procedure.

Tables Used

sysalerts, sysnotifications, sysoperators

See Also