Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)