Returns information on agent jobs that generate filtered data snapshots. This stored procedure is executed at the Publisher on the publication database.
Identifies the filtered data snapshot job.
Name of the filtered data snapshot job.
Identifies the Microsoft SQL Server Agent job at the Distributor.
Value used for evaluating the SUSER_SNAME function in a parameterized row filter defined for the publication.
Value used for evaluating the HOST_NAME function in a parameterized row filter defined for the publication.
Path to the folder where the snapshot files are read from if a parameterized row filter is used.
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
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
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
Number of intervals of frequency_subday_type that occur between scheduled execution of the agent.
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
Number of weeks or months between the scheduled execution of the agent.
Date when the agent is first scheduled to run, formatted as YYYYMMDD.
Date when the agent is last scheduled to run, formatted as YYYYMMDD.
Time when the agent is first scheduled to run, formatted as HHMMSS.
Time when the agent is last scheduled to run, formatted as HHMMSS.