MSsubscriber_schedule (Transact-SQL)

The MSsubscriber_schedule table contains default merge and transactional synchronization schedules for each Publisher/Subscriber pair. This table is stored in the distribution database.

Note

This system table has been deprecated and is being maintained to support earlier versions of Microsoft SQL Server.

Column name

Data type

Description

publisher

sysname

The name of the Publisher.

subscriber

sysname

The name of the Subscriber.

agent_type

smallint

The type of agent:

0 = Distribution Agent.

1 = Merge Agent.

frequency_type

int

The frequency with which to schedule the Distribution Agent:

1 = One time.

2 = On demand.

4 = Daily.

8 = Weekly.

16 = Monthly.

32 = Monthly relative.

64 = Autostart.

128 = Recurring.

frequency_interval

int

The value to apply to the frequency set by frequency_type.

frequency_relative_interval

int

The date of the Distribution Agent:

1 = First.

2 = Second.

4 = Third.

8 = Fourth.

16 = Last.

frequency_recurrence_factor

int

The recurrence factor used by frequency_type.

frequency_subday

int

How often to reschedule during the defined period:

1 = Once.

2 = Second.

4 = Minute.

8 = Hour.

frequency_subday_interval

int

The interval for frequency_subday.

active_start_time_of_day

int

The time of day when the Distribution Agent will first be scheduled, formatted as HHMMSS.

active_end_time_of_day

int

The time of day when the Distribution Agent will stop being scheduled, formatted as HHMMSS.

active_start_date

int

The date when the Distribution Agent will first be scheduled, formatted as YYYYMMDD.

active_end_date

int

The date when the Distribution Agent will stop being scheduled, formatted as YYYYMMDD.