Jaa


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.

See Also

Tasks

How to: Create an Alert Using Severity Level (SQL Server Management Studio)
How to: Create an Alert Using an Error Number (SQL Server Management Studio)

Help and Information

Getting SQL Server 2005 Assistance