LastDistributionStatus Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The LastDistributionStatus property returns the current status of Distribution Agent as it synchronizes the referenced subscription.

語法

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);

附註：
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