Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The AgentsStatus property returns a value representing, the current state of replication jobs affecting a distribution database or providing services for a distribution Publisher.
Syntax
object
.AgentsStatus
Parts
- object
An 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 failed to run 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 run after a previous failure. |
SQLDMOTask_Running |
3 |
At least one job is running. |
SQLDMOTask_Starting |
1 |
At least one job is starting. |
SQLDMOTask_Succeeded |
2 |
All jobs have run successfully. |