Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

MSsnapshot_history (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft