Alerts Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
The Alerts Wizard lets you build and submit an sp_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:
- Open an object creation wizard for an alert. For details, see Opening an Object Wizard.
- 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.
- Finally, use the Execute button to create the object.
For information on related SQL Agent elements, see the following topics:
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, and 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).