MSsnapshot_history (Transact-SQL)


Applies To: 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 nameData typeDescription
agent_idintThe ID of the Snapshot Agent.
runstatusintThe running status:

 1 = Start.

 2 = Succeed.

 3 = In progress.

 4 = Idle.

 5 = Retry.

 6 = Fail.
start_timedatetimeThe time to begin execution of the job.
timedatetimeThe time the message is logged.
durationintThe duration, in seconds, of the message session.
commentsnvarchar(255)The message text.
delivered_transactionsintThe total number of transactions delivered in the session.
delivered_commandsintThe number of delivered commands per second.
delivery_ratefloat(53)The average delivered commands per second.
error_idintThe ID of the error in the MSrepl_errors system table.
timestamptimestampThe timestamp column of this table.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions