| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSsubscriber_schedule (Transact-SQL) |
MSsubscriber_schedule (Transact-SQL) |
VanMSFT |
vanto |
03/14/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion].
| 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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)