Freigeben über


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.

Siehe auch

Andere Ressourcen

SQL Server-Agent

Hilfe und Informationen

Informationsquellen für SQL Server 2005