AlertSystem Object
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。
The AlertSystem object represents properties and behaviors of the SQL Server Agent alert notification for all defined alerts.
.gif "現在のオブジェクトを表す SQL-DMO オブジェクト モデル")
Properties
|
Methods
解説
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
Get the AlertSystem object from the JobServer object of a connected SQLServer object.
Use the BeginAlter method to mark the start of changes to the object properties.
Change property values to reflect changes in alert notification behavior.
Use the DoAlter method to mark the end of changes and submit them to SQL Server Agent.