Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 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)