다음을 통해 공유

  • 아티클

EnumDistributionAgentSessionDetails 메서드

Returns detailed information about a Distribution Agent session.

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo.dll의 Microsoft.SqlServer.Rmo

구문

‘선언
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

매개 변수

반환 값

형식: 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.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.