SQL-DMO
AgentsStatus Property
The AgentsStatus property returns a value representing, roughly, the current state of replication jobs affecting a distribution database or providing services for a distribution Publisher.
Applies To
| DistributionDatabase Object |
Syntax
object.AgentsStatus
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetAgentsStatus(SQLDMO_TASKSTATUS_TYPE* pRetVal);
Returns
| Constant | Value | Description |
|---|---|---|
| SQLDMOTask_Failed | 6 | At least one job has failed to execute successfully |
| SQLDMOTask_Idle | 4 | All jobs are scheduled and idle |
| SQLDMOTask_Pending | 0 | All jobs are waiting to start |
| SQLDMOTask_Retry | 5 | At least one job is attempting to execute after a previous failure |
| SQLDMOTask_Running | 3 | At least one job is executing |
| SQLDMOTask_Starting | 1 | One or more jobs are starting |
| SQLDMOTask_Succeeded | 2 | All jobs have successfully executed |