SQL-DMO
JobServer Object
The JobServer object exposes attributes associated with SQL Server Agent. SQL Server Agent is responsible for executing scheduled jobs and notifying operators of Microsoft® SQL Server™ 2000 error conditions or other SQL Server execution or job states.
Properties
| AutoStart Property | Status Property (Services) |
| MSXServerName Property | Type Property (JobServer) |
| StartupAccount Property |
Methods
Remarks
With the JobServer object, you can:
- Start or stop SQL Server Agent on a server running SQL Server.
- Manage alerts, jobs, and operators.
- Enlist the server in a multiserver administration group.
Note The JobServer object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the JobServer2 object extends the functionality of the JobServer object for use with features that are new in SQL Server 2000.