MSsnapshot_history (Transact-SQL)
The MSsnapshot_history table contains history rows for the Snapshot 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 Snapshot 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(255) |
The message text. |
|
delivered_transactions |
int |
The total number of transactions delivered in the session. |
|
delivered_commands |
int |
The number of delivered commands per second. |
|
delivery_rate |
float(53) |
The average delivered commands per second. |
|
error_id |
int |
The ID of the error in the MSrepl_errors system table. |
|
timestamp |
timestamp |
The timestamp column of this table. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables
