次の方法で共有


Operator Object

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

The Operator object represents a single Microsoft SQL Server operator. SQL Server operators receive alert and job status notification in response to events generated by the server.

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

Properties

Category Property

Name Property

EmailAddress Property

NetSendAddress Property

Enabled Property

PagerAddress Property

ID Property

PagerDays Property

LastEmailDate Property

SaturdayPagerEndTime Property

LastEmailTime Property

SaturdayPagerStartTime Property

LastNetSendDate Property

SundayPagerEndTime Property

LastNetSendTime Property

SundayPagerStartTime Property

LastPageDate Property

WeekdayPagerEndTime Property

LastPageTime Property

WeekdayPagerStartTime Property

Methods

AddNotification Method

Refresh Method

BeginAlter Method

Remove Method (Operator)

CancelAlter Method

RemoveNotification Method

DoAlter Method

Script Method

EnumJobNotifications Method

UpdateNotification Method

EnumNotifications Method

 

解説

Use the Operator object to manage the SQL Server operators defined for an instance of SQL Server. With the Operator object, you can:

  • Define new operators on an instance of SQL Server.
  • Assign alert notifications to the operator.
  • Change the scheduled response times for an existing operator.

The Name property of an Operator object is required when creating an operator on SQL Server. The Name property uses the SQL Server data type varchar(100).

A SQL Server operator created with the minimum required values has no schedule information and is assigned no notifications.

To create a SQL Server operator

  1. Create an Operator object.

  2. Set the Name property.

  3. Add the Operator object to the Operators collection of a connected JobServer object.

To modify an existing SQL Server operator

  1. Get an Operator object from the Operators collection of a connected JobServer object.

  2. Use the BeginAlter method to mark the start of changes to existing property values.

  3. Change property values to reflect changes in behavior.

  4. Use the DoAlter method to mark the end of changes and make changes in the SQL Server operator.

参照

その他の技術情報

オペレータの定義

ヘルプおよび情報

SQL Server 2005 の参考資料の入手