How to: Delete an Alert (SQL Server Management Studio)
This topic describes how to delete Microsoft SQL Server Agent alerts.
To delete an alert
In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
Expand SQL Server Agent.
Expand Alerts.
Right-click an alert, and then click Delete.
On the Delete Object dialog box, confirm the deletion.