Alerts Wizard (SQL Server)

From DBArtisan
Jump to: navigation, search

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:

  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:
  3. 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).