MSsubscriber_schedule

Transact-SQL Reference

Transact-SQL Reference

MSsubscriber_schedule

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

Column name Data type Description
publisher sysname Name of the Publisher.
subscriber sysname Name of the Subscriber.
agent_type smallint Type of agent:

0 = Distribution Agent
1 = Merge Agent

frequency_type int 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 (default)
124 = Recurring

frequency_interval int Value to apply to the frequency set by frequency_type.
frequency_relative_interval int Date of the Distribution Agent:

1 = First (default)
2 = Second
4 = Third
8 = Fourth
16 = Last

frequency_recurrence_factor int Recurrence factor used by frequency_type.
frequency_subday int How often to reschedule during the defined period:

1 = Once
2 = Second
4 = Minute (default)
8 = Hour

frequency_subday_interval int Interval for frequency_subday.
active_start_time_of_day int Time of day when the Distribution Agent will first be scheduled, formatted as HHMMSS.
active_end_time_of_day int Time of day when the Distribution Agent will stop being scheduled, formatted as HHMMSS.
active_start_date int Date when the Distribution Agent will first be scheduled, formatted as YYYYMMDD.
active_end_date int Date when the Distribution Agent will stop being scheduled, formatted as YYYYMMDD.