Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSsnapshot_history

SQL Server 2000

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 ID of the Snapshot Agent.
runstatus int Running status:

1 = Start
2 = Succeed
3 = In progress
4 = Idle
5 = Retry
6 = Fail

start_time datetime Time to begin execution of the job.
time datetime Time the message is logged.
duration int Duration, in seconds, of the message session.
comments nvarchar(255) Message text.
delivered_transactions int Total number of transactions delivered in the session.
delivered_commands int Number of delivered commands per second.
delivery_rate float Average delivered commands per second.
error_id int ID of the error in the MSrepl_error system table.
timestamp timestamp Timestamp column of this table.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.