Share via


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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance