共用方式為


PublisherMonitor.EnumDistributionAgentSessionDetails 方法

Returns detailed information about a Distribution Agent session.

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public Function EnumDistributionAgentSessionDetails ( _
    agentName As String, _
    sessionId As String _
) As DataSet
'用途
Dim instance As PublisherMonitor 
Dim agentName As String 
Dim sessionId As String 
Dim returnValue As DataSet 

returnValue = instance.EnumDistributionAgentSessionDetails(agentName, _
    sessionId)
public DataSet EnumDistributionAgentSessionDetails(
    string agentName,
    string sessionId
)
public:
DataSet^ EnumDistributionAgentSessionDetails(
    String^ agentName, 
    String^ sessionId
)
member EnumDistributionAgentSessionDetails : 
        agentName:string * 
        sessionId:string -> DataSet
public function EnumDistributionAgentSessionDetails(
    agentName : String, 
    sessionId : String
) : DataSet

參數

  • agentName
    型別:System.String
    A String value that specifies the name of the Distribution Agent.

傳回值

型別:System.Data.DataSet
A DataSet object that contains the following columns.

Column

Data type

Description

runstatus

Int32

The running status:

1 = Start

2 = Succeed

3 = In progress

4 = Idle

5 = Retry

6 = Fail

time

DateTime

Time of logging for session detail.

comments

String

Descriptive text.

duration

Int32

Elapsed time of the logged session activity, in seconds.

delivery_rate

Single

Average number of commands delivered per second.

delivery_latency

Int32

Latency, in milliseconds, between the transaction entering the distribution database and being applied to the Subscriber.

(No column name)

Not applicable

Internal use only.

delivered_transactions

Int32

Total number of transactions delivered in the session.

delivered_commands

Int32

Total number of commands delivered in the session.

average_commands

Int32

Average number of commands per transaction delivered in the session.

error_id

Int32

The ID of the error in the MSrepl_errors (Transact-SQL) system table. Use the EnumErrorRecords method to return detailed information about an error.

備註

The EnumDistributionAgentSessionDetails method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.

請參閱

參考

PublisherMonitor 類別

Microsoft.SqlServer.Replication 命名空間

其他資源

以程式設計方式監視複寫 (RMO 程式設計)