AgentsStatus Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The AgentsStatus property returns a value representing, the current state of replication jobs affecting a distribution database or providing services for a distribution Publisher.

Sintaxis

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.

Applies To:

DistributionDatabase Object