Alerts Collection (SQL-DMO)

The Alerts collection contains Alert objects referencing SQL Server Agent alerts.

Remarks

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")

    

Methods