Contains history rows for the Distribution Agents associated with the local Distributor. This table is stored in the distribution database.
Column name | Data type | Description |
---|---|---|
agent_id | int | ID of the Distribution Agent. |
runstatus | int | Running status: 0 = Start 2 = Succeed 3 = In progress 4 = Idle 5 = Retry 6 = Fail |
start_time | datetime | Time to begin execution of the job. |
time | datetime | Time the message is logged. |
duration | int | Duration, in seconds, of the message session. |
comments | nvarchar(255) | Message text. |
xact_seqno | varbinary(16) | Last processed transaction sequence number. |
current_delivery_rate | float | Average number of commands delivered per second since the last history entry. |
current_delivery_latency | int | Latency between the command entering the distribution database and being applied to the Subscriber since the last history entry. |
delivered_transactions | int | Total number of transactions delivered in the session. |
delivered_commands | int | Total number of commands delivered in the session. |
average_commands | int | Average number of commands delivered in the session. |
delivery_rate | float | Average delivered commands per second. |
delivery_latency | int | Latency between the command entering the distribution database and being applied to the Subscriber. |
total_delivered_commands | int | Total number of commands delivered since the subscription was created. |
error_id | int | ID of the error in the MSrepl_error system table. |
updateable_row | bit | Set if the history row can be overwritten. |
timestamp | timestamp | Timestamp column of this table. |