PublisherMonitor.EnumDistributionAgentSessionDetails Method
Returns detailed information about a Distribution Agent session.
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
public DataSet EnumDistributionAgentSessionDetails( string agentName, string sessionId )
Parameters
- agentName
- Type: System.String
A String value that specifies the name of the Distribution Agent.
- sessionId
- Type: System.String
A String value that represents the data and time of the session for which details are returned. This value can be obtained from the time column returned by the EnumDistributionAgentSessions method.
Return Value
Type: System.Data.DataSetA DataSet object that contains the following columns.
Column | Data type | Description |
|---|---|---|
runstatus | The running status: 1 = Start 2 = Succeed 3 = In progress 4 = Idle 5 = Retry 6 = Fail | |
time | Time of logging for session detail. | |
comments | Descriptive text. | |
duration | Elapsed time of the logged session activity, in seconds. | |
delivery_rate | Average number of commands delivered per second. | |
delivery_latency | 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 | Total number of transactions delivered in the session. | |
delivered_commands | Total number of commands delivered in the session. | |
average_commands | Average number of commands per transaction delivered in the session. | |
error_id | The ID of the error in the MSrepl_errors (Transact-SQL) system table. Use the EnumErrorRecords method to return detailed information about an error. |
