| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSsnapshot_history (Transact-SQL) |
MSsnapshot_history (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)