共用方式為

Alerts Collection

  • 發行項

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

The Alerts collection contains Alert objects that reference SQL Server Agent alerts.

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

Methods

Add Method

Remove Method (Collections)

ItemByID Method

Script Method

Refresh Method

 

備註

With the Alerts collection, you can:

  • Create a Microsoft SQL Server alert.
  • Completely remove a SQL Server alert.

For information about creating SQL Server alerts, see Alert Object.

To remove an alert

  • Use the Remove method of the Alerts collection of a connected JobServer object. Indicate the targeted alert using the alert name or the ordinal location in the collection, as in:

    oJobServer.Alerts.Remove("Full Northwind")