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.

See Also

Other Resources

SQL Server Agent

Help and Information

Getting SQL Server 2005 Assistance