Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft