MSqreader_history (Transact-SQL)


Applies To: SQL Server

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 nameData typeDescription
agent_idintThe ID of the Queue Reader Agent.
publication_idintThe ID of the publication.
runstatusintThe running state of the agent:

 1 = Start.

 2 = Succeed.

 3 = In progress.

 4 = Idle.

 5 = Retry.

 6 = Fail.
start_timedatetimeThe date and time at which agent session started.
timedatetimeThe date and time of last logged message.
durationintThe elapsed time of the logged session activity, in seconds.
commentsnvarchar(255)The descriptive text.
transaction_idnvarchar(40)The transaction ID stored with the message, if applicable.
transaction_statusintThe status of the transaction.
transactions_processedintThe cumulative number of transactions processed in the session.
commands_processedintThe cumulative number of commands processed in the session.
delivery_ratefloat(53)The average number of commands delivered per second.
transaction_ratefloat(53)The rate of transactions processed.
subscribersysnameThe name of the Subscriber.
subscriberdbsysnameThe name of the subscription database.
error_idintIf not zero, the number represents a Microsoft SQL Server error message.
timestamptimestampThe timestamp column for the table.

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

Community Additions