Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

AgentsStatus Property

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.

object.AgentsStatus

object

An expression that evaluates to an object in the Applies To list.

Read-only

HRESULT GetAgentsStatus(SQLDMO_TASKSTATUS_TYPE* pRetVal);

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.

Community Additions

ADD
Show:
© 2015 Microsoft