MSdistribution_history (Transact-SQL)
The MSdistribution_history table contains history rows for the Distribution Agents associated with the local Distributor. This table is stored in the distribution database.
Definition
| Column name | Data type | Description |
|---|---|---|
agent_id |
int |
The ID of the Distribution Agent. |
runstatus |
int |
The Running status: 1 = Start. 2 = Succeed. 3 = In progress. 4 = Idle. 5 = Retry. 6 = Fail. |
start_time |
datetime |
The time to begin execution of the job. |
time |
datetime |
The time the message is logged. |
duration |
int |
The duration, in seconds, of the message session. |
comments |
nvarchar(4000) |
The message text. |
xact_seqno |
varbinary(16) |
The last processed transaction sequence number. |
current_delivery_rate |
float |
The average number of commands delivered per second since the last history entry. |
current_delivery_latency |
int |
The latency between the command entering the distribution database and being applied to the Subscriber since the last history entry. |
delivered_transactions |
int |
The total number of transactions delivered in the session. |
delivered_commands |
int |
The total number of commands delivered in the session. |
average_commands |
int |
The average number of commands delivered in the session. |
delivery_rate |
float |
The average delivered commands per second. |
delivery_latency |
int |
The latency between the command entering the distribution database and being applied to the Subscriber. |
total_delivered_commands |
int |
The total number of commands delivered since the subscription was created. |
error_id |
int |
The ID of the error in the MSrepl_error system table. |
updateable_row |
bit |
The set if the history row can be overwritten. |
timestamp |
timestamp |
The timestamp column of this 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