Alert Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The Alert object represents a single SQL Server Agent alert. Alerts respond to either specific Microsoft SQL Server error messages or SQL Server errors of a specified severity.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

Category Property

JobID Property

CountResetDate Property

JobName Property

CountResetTime Property (SQL-DMO)

LastOccurrenceDate Property

DatabaseName Property

LastOccurrenceTime Property

DelayBetweenResponses Property

LastResponseDate Property

Enabled Property

LastResponseTime Property

EventCategoryID Property

MessageID Property

EventDescriptionKeyword Property

Name Property

EventID Property

NotificationMessage Property

EventSource Property

OccurrenceCount Property

HasNotification Property

PerformanceCondition Property

ID Property

Severity Property

IncludeEventDescription Property

Type Property (Alert)

Methods

AddNotification Method

Remove Method (Objects)

BeginAlter Method

RemoveNotification Method

CancelAlter Method

ResetOccurrenceCount Method

DoAlter Method

Script Method

EnumNotifications Method

UpdateNotification Method

Refresh Method

 

解説

You can use the Alert object to create and manage SQL Server Agent alerts:

  • Create an alert to respond to a specific SQL Server error.
  • Change the properties of an existing alert to modify its behavior.
  • Change the notified operators on an instance of the error condition.

The Name property of an Alert object uses the SQL Server data type sysname. The string must be a unique value for each Alert object in the Alerts collection.

SQL Server does not allow the creation of more than one alert on any given error condition or severity level. More than one alert can be defined on a specific message identifier; however, each alert defined must be limited in scope by associating the alert with a specific database.

SQL Server alerts are enabled by default. However, an alert created with the minimum required values will fire no notifications. You must assign operators to the alert by using the AddNotification method of the Alert or Operator object.

To create an alert

  1. Create an Alert object.

  2. Set the Name property.

  3. Set the response type for the alert by setting the value of the Severity property or the MessageID property.

  4. Set any optional properties you want. For example, set the DatabaseName property to limit the alert's action to a specific database, or use the AddNotification method to add operators to the alert.

  5. Add the Alert object to the Alerts collection of a connected JobServer object.

To alter an existing alert

  1. Get an Alert object from the Alerts collection of a connected JobServer object.

  2. Use the BeginAlter method to mark the beginning of the changes.

  3. Set the Alert object properties to reflect changes in alert behaviors.

  4. Use the DoAlter method to submit the alert changes to SQL Server.

参照

関連項目

Operator Object

その他の技術情報

警告の定義

ヘルプおよび情報

SQL Server 2005 の参考資料の入手