共用方式為


AlertSystem Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The AlertSystem object represents properties and behaviors of the SQL Server Agent alert notification for all defined alerts.

顯示目前物件的 SQL-DMO 物件模型

Properties

FailSafeOperator Property

PagerCCTemplate Property

ForwardAlways Property

PagerSendSubjectOnly Property

ForwardingServer Property

PagerSubjectTemplate Property

ForwardingSeverity Property

PagerToTemplate Property

NotificationMethod Property

 

Methods

BeginAlter Method

DoAlter Method

CancelAlter Method

Refresh Method

備註

The AlertSystem object represents properties set for a single instance of SQL Server Agent. There is a single AlertSystem object for a SQLServer object, and new AlertSystem objects cannot be created.

With the AlertSystem object, you can:

  • Register an operator for fail-safe response.
  • Change the look of address lines on e-mail and pager notices sent as part of alert notification.

To change the alert notification behavior of SQL Server Agent

  1. Get the AlertSystem object from the JobServer object of a connected SQLServer object.

  2. Use the BeginAlter method to mark the start of changes to the object properties.

  3. Change property values to reflect changes in alert notification behavior.

  4. Use the DoAlter method to mark the end of changes and submit them to SQL Server Agent.

請參閱

其他資源

定義操作員
管理事件

說明及資訊

取得 SQL Server 2005 協助