This documentation is archived and is not being maintained.

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.