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