Modifying and Viewing Alerts
After you create an alert, you can:
- View the alert's information.
You can view the characteristics of an alert, the date of the most recent occurrence of and response to the alert, as well as the number of times the alert has occurred since the count was last reset.
- Modify the alert's information.
You can add new operators, reset the number of times an alert has occurred, disable an alert, or change a database.
- Delete the alert.
You can delete an alert that is no longer needed. When you delete an alert, you also delete all of the alert's operator notifications.
To view information about an alert
Transact-SQLTo edit an alert
To delete an alert