AlertSystem Object

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

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

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 지원 받기