Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


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.

© 2015 Microsoft