MSqreader_history (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The MSqreader_history table contains history rows for the Queue 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 Queue Reader Agent.
publication_id int The ID of the publication.
runstatus int The running state of the agent:

1 = Start.

2 = Succeed.

3 = In progress.

4 = Idle.

5 = Retry.

6 = Fail.
start_time datetime The date and time at which agent session started.
time datetime The date and time of last logged message.
duration int The elapsed time of the logged session activity, in seconds.
comments nvarchar(255) The descriptive text.
transaction_id nvarchar(40) The transaction ID stored with the message, if applicable.
transaction_status int The status of the transaction.
transactions_processed int The cumulative number of transactions processed in the session.
commands_processed int The cumulative number of commands processed in the session.
delivery_rate float(53) The average number of commands delivered per second.
transaction_rate float(53) The rate of transactions processed.
subscriber sysname The name of the Subscriber.
subscriberdb sysname The name of the subscription database.
error_id int If not zero, the number represents a Microsoft SQL Server error message.
timestamp timestamp The timestamp column for the table.

See Also

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