LastDistributionStatus 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 LastDistributionStatus property returns the current status of Distribution Agent as it synchronizes the referenced subscription.

Sintaxis

object
.LastDistributionStatus

Parts

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

Returns

The LastDistributionStatus property returns these SQLDMO_TASKSTATUS_TYPE values.

Constant	Value	Description
SQLDMOTask_Failed	6	At least one job failed to execute.
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	At least one job is starting.
SQLDMOTask_Succeeded	2	All jobs executed successfully.

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetLastDistributionStatus(SQLDMO_TASKSTATUS_TYPE *pRetVal);

[!NOTA] If an application calls LastDistributionStatus on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

TransPullSubscription2 Object