Alerts Editor (SQL Server)

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
Properties	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.
Response	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.