mslogreader-history-transact-sql.md

title	MSlogreader_history (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSlogreader_history_TSQL MSlogreader_history
dev_langs	TSQL
helpviewer_keywords	MSlogreader_history system table
ms.assetid	2e399fa1-3591-4c1c-96b7-7964fe82c7c4
author	stevestein
ms.author	sstein

MSlogreader_history (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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. In milliseconds.
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

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)