Articolo
09/28/2010

JobServer Object

Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

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 error conditions or other SQL Server execution or job states.

Modello di oggetti SQL-DMO in cui è visualizzato l'oggetto corrente

Properties

AutoStart Property	Status Property (Services)
MSXServerName Property	Type Property (JobServer)
StartupAccount Property

Methods

BeginAlter Method	ReAssignJobsByLogin Method
CancelAlter Method	Refresh Method
DoAlter Method	RemoveJobByID Method
EnumJobHistory Method	RemoveJobsByLogin Method
EnumJobs Method	RemoveJobsByServer Method
EnumSubSystems Method	Start Method (FullTextService, JobServer)
GetJobByID Method	StartMonitor Method
MSXDefect Method	Stop Method
MSXEnlist Method	StopMonitor Method
PurgeJobHistory Method

Osservazioni

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.

[!NOTA]

The JobServer object is compatible with instances of SQL Server versions 7.0 and later. However, the JobServer2 object extends the functionality of the JobServer object for use with features that were introduced in SQL Server 2000.

Vedere anche

Riferimento

JobServer2 Object

Share via