How to: Edit an Alert (SQL Server Management Studio)
This topic describes how to edit a Microsoft SQL Server Agent alert. You can change the database for which the alert is raised, the events that alerts respond to, the operators who are notified, and whether the alert error text is included in alert notifications.
To edit 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 Properties.
Update the alert properties on the General,Response, andOptions pages.
How to: Create an Alert Using an Error Number (SQL Server Management Studio)
How to: Create an Alert Using Severity Level (SQL Server Management Studio)
How to: Define the Response to an Alert (SQL Server Management Studio)