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