MSsubscriber_schedule (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)