Removes an alert.
sp_delete_alert [ @name = ] 'name'
[@name =] 'name'
Is the name of the alert. name is sysname, with no default.
Return Code Values
0 (success) or 1 (failure)
Removing an alert also removes any notifications associated with the alert.
sp_delete_alert must be executed in the msdb database.
Only members of the sysadmin fixed server role can execute sp_delete_alert.
This example removes an alert named Test Alert.
sp_delete 'Test Alert'