The MSlogreader_history table contains history rows for the Log Reader Agents associated with the local Distributor. This table is stored in the distribution database.
|
Column name
|
Data type
|
Description
|
|---|
|
agent_id
|
int
|
The ID of the Log Reader 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(255)
|
The message text.
|
|
xact_seqno
|
varbinary(16)
|
The last processed transaction sequence number.
|
|
delivery_time
|
int
|
The time first transaction is delivered.
|
|
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 published database and being entered into the distribution database.
|
|
error_id
|
int
|
The ID of the error in the MSrepl_error system table.
|
|
timestamp
|
timestamp
|
The timestamp column of this table.
|
|
updateable_row
|
bit
|
Set to 1 if the history row can be overwritten.
|
See Also