SQL-DMO
Alerts Collection
The Alerts collection contains Alert objects that reference SQL Server Agent alerts.
Methods
| Add Method | Remove Method (Collections) |
| ItemByID Method | Script Method |
| Refresh Method |
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")