How to: View Information About an Alert (SQL Server Management Studio)

This topic describes how to view information about Microsoft SQL Server Agent alerts.

To view information about an alert

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent.

  3. Expand Alerts. Right-click an alert and then click Properties.

    On the General page, you can view the type of alert and its definition. On the Response page, you can view the actions that occur when the alert is triggered. On the Options page, you can view which notification method is used for the alert and any additional text that will be sent with the notification message. On the History page, you can view the date the alert last occurred, the date the alert was last responded to, and the number of times the alert was triggered since the last time the count was reset.