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. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables