Alerts Wizard (SQL Server)

Go Up to Microsoft SQL Server Object Wizards

The Alerts Wizard lets you build and submit ansp_add_alert call to create a SQL Agent Alert. You can create event-based, performance-based, or WMI-based alerts. Job-based and operator-based responses are available.

Note: For an overview of SQL Agent service support, see SQL Server Agent.

To create a new alert using a wizard

1. Open an object creation wizard for an alert. For details, see Opening an Object Wizard.
2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
   • Properties panel. For details see Alerts (SQL Server) - Properties.
   • Response panel. For details see Alerts (SQL Server) - Response.
   • DDL View panel. For details, see Previewing the DDL Generated to Create the New Object.
3. Click Execute to create the object.

For information on related SQL Agent elements, see the following topics:

• Jobs Wizard (SQL Server)
• Operators Wizard (SQL Server)

Alerts (SQL Server) - Properties

When creating or editing an alert, this tab/panel lets you select an alert type and provide details on the type selected. It has the following settings:

Category	Property	Description
Creation	Name	Provide a name for the alert.
	Enabled	Select this check box to enable the alert.
	Type	Select an alert type of SQL SERVER EVENT ALERT, SQL SERVER PERFORMANCE CONDITION ALERT, or WMI EVENT ALERT.
Alert definition	If you selected a Type of SQL SERVER EVENT ALERT, select or provide the following details.
	Error #	Type a valid, native or user-defined error number.
	Error Description	Displays the textual description for the Error # you specified.
	Severity	Select a severity to be associated/displayed for this alert.
	Database	If you want to restrict this alert to be reported on a specific database, select a specific database.
	Event Description	Provide a textual description to be displayed with the alert.
	If you selected a Type of SQL SERVER PERFORMANCE CONDITION ALERT, select or provide the following details.
	Object	Select the performance object to be monitored. Available performance objects differ by the version of SQL Server you are using. They MAY include: Access Methods Backup Device Broker Activation Broker Statistics Broker/DBM Transport Buffer Manager Buffer Node Buffer Partition Cache Manager Catalog Metadata CLR Cursor Management by Type Cursor Management Total Database Mirroring Databases Deprecated Features Exec Statistics General Statistics Latches Locks Memory Manager Plan Cache Resource Pool Stats SQL Errors SQL Statistics Transactions User Settable Wait Statistics Workload Group Stats
	Counter	Select a counter specific to the performance Object you selected.
	Instance	If a specific instance is available for the Object and Counter you selected, select an instance.
	Alert if counter and Value	Use these settings to select the relational operator (<, =,or >) and value that make up the condition for which the alert is generated.
	If you selected a Type of WMI EVENT ALERT, select or provide the following details.
	Namespace	Type the WMI namespace for the WMI Query Language (WQL) statement that identifies which WMI event will trigger this alert.
	Query	Type the WQL statement that identifies the event that this alert responds to.

Alerts (SQL Server) - Response

When creating or editing an alert, this tab/panel lets you specify details of responses to the alert. It lets you specify a job to be executed as well as details of email, pager or net send notifications. You work with the following settings:

Category	Property	Description
Job Properties	Execute Job	Select this check box to have a job executed on this alert.
	Job Name	If you selected Execute Job, select the specific job to execute.
Include alert error text in	Use the Email, Pager, and Net send controls to specify whether a textual description of the SQL Server error is to be included as part of the notification message for the target media.
Additional Properties	Notification message	Use this control to add an optional additional message that will be sent to the operator as part of the notification.
	Delay Between Responses	The wait period, in seconds, between responses to the alert.
Operators to notify	The list displays all defined operators. Use the Email, Pager, and Netsend controls to select the operators and the media by which they will be contacted for this alert.

Note: The New Job and New Operator buttons let you open the Jobs Wizard and Operators Wizard, respectively. For details, see Jobs Wizard (SQL Server) and Operators Wizard (SQL Server).