Alerts Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Alerts Editor lets you modify the definition of a SQL Agent alert.

To edit an alert

  1. Open an editor on the alert. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


This tab/panels lets you view the ID, Name, and Error Description settings. It lets you modify the Enabled, Type, Error #, Severity, Database, and Event Description settings. For details on these settings, see Alerts (SQL Server) - Properties. The History and Occurrence groups display the following properties:

Last Occurrence Date

The date and time that this alert was last raised.

Last Response Date

The date and time that this alert was responded to by the SQLServerAgent service.

Occurrence Count

The number of times this alert occurred since last being reset.

Last Reset Date

The date and time that the Occurrence Date was last reset.

Reset Count

Use this button to set the Occurrence Date to zero.


This tab lets you provide job execution details, set content of email, pager, and net send notifications, and select operators notified, for this alert. For details on the specific properties, see Alerts (SQL Server) - Response.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.