Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_helppublication_snapshot (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).

Returns information on the Snapshot agent for a given publication. This stored procedure is executed at the Publisher on the publication database.

Topic link icon Transact-SQL Syntax Conventions

sp_helppublication_snapshot [ @publication = ] 'publication'
    [ , [ @publisher = ] 'publisher' ]

[ @publication = ] 'publication'

Is the name of the publication. publication is sysname, with no default.

[ @publisher = ] 'publisher'

Specifies a non-SQL Server publisher. publisher is sysname, with a default of NULL.

Note Note

publisher should not be used when adding an article to a SQL Server Publisher.

Column name

Data type

Description

id

int

ID of the Snapshot Agent.

name

nvarchar(100)

Name of the Snapshot Agent.

publisher_security_mode

smallint

Security mode used by the agent when connecting to the Publisher, which can be one of the following:

0 = SQL Server Authentication

1 = Windows Authentication.

publisher_login

sysname

Login used when connecting to the Publisher.

publisher_password

nvarchar(524)

For security reasons, a value of ********** is always returned.

job_id

uniqueidentifier

Unique ID of the agent job.

job_login

nvarchar(512)

Is the Windows account under which the Snapshot agent runs, which is returned in the format DOMAIN\username.

job_password

sysname

For security reasons, a value of ********** is always returned.

schedule_name

sysname

Name of the schedule used for this agent job.

frequency_type

int

Is the frequency with which the agent is scheduled to run, which can be one of these values.

1 = One time

2 = On demand

4 = Daily

8 = Weekly

16 = Monthly

32 = Monthly relative

64 = Autostart

128 = Recurring

frequency_interval

int

The days that the agent runs, which can be one of these values.

1 = Sunday

2 = Monday

3 = Tuesday

4 = Wednesday

5 = Thursday

6 = Friday

7 = Saturday

8 = Day

9 = Weekdays

10 = Weekend days

frequency_subday_type

int

Is the type that defines how often the agent runs when frequency_type is 4 (daily), and can be one of these values.

1 = At the specified time

2 = Seconds

4 = Minutes

8 = Hours

frequency_subday_interval

int

Number of intervals of frequency_subday_type that occur between scheduled execution of the agent.

frequency_relative_interval

int

Is the week that the agent runs in a given month when frequency_type is 32 (monthly relative), and can be one of these values.

1 = First

2 = Second

4 = Third

8 = Fourth

16 = Last

frequency_recurrence_factor

int

Number of weeks or months between the scheduled execution of the agent.

active_start_date

int

Date when the agent is first scheduled to run, formatted as YYYYMMDD.

active_end_date

int

Date when the agent is last scheduled to run, formatted as YYYYMMDD.

active_start_time

int

Time when the agent is first scheduled to run, formatted as HHMMSS.

active_end_time

int

Time when the agent is last scheduled to run, formatted as HHMMSS.

0 (success) or 1 (failure)

sp_help_publication_snapshot is used in all types of replication.

Only members of the sysadmin fixed server role at the Publisher or members of the db_owner fixed database role on the publication database can execute sp_help_publication_snapshot.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft