Scheduling Automatic Administrative Tasks in SQL Server Agent
In SMO, the SQL Server Agent is represented by the following objects:
- The JobServer object has three collections of jobs, alerts and operators.
- The OperatorCollection object represents a list of pager, e-mail addresses and net send operators that can be notified of events automatically by the Microsoft SQL Server Agent.
- The AlertCollection object represents a list of circumstances such as system events or performance conditions that are monitored by SQL Server.
- The JobCollection object is slightly more complex. It represents a list of multi-step tasks that run at specified schedules. The steps and schedule information are stored in the JobStep and JobSchedule objects.
The SQL Server Agent objects are in the Microsoft.SqlServer.Management.Smo.Agent namespace.