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. |