MSlogreader_history

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	ID of the Log Reader Agent.
runstatus	int	Running status: 1 = 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.
delivery_time	int	Time first transaction is delivered.
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 published database and being entered into the distribution database.
error_id	int	ID of the error in the MSrepl_error system table.
timestamp	timestamp	Timestamp column of this table.

'

< THANKS ME>