MSqreader_history (Transact-SQL)
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
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables