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.