TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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.

System_CAPS_ICON_note.jpg Note


This system table has been deprecated and is being maintained to support earlier versions of MicrosoftSQL Server.

Column nameData typeDescription
publishersysnameThe name of the Publisher.
subscribersysnameThe name of the Subscriber.
agent_typesmallintThe type of agent:

0 = Distribution Agent.

1 = Merge Agent.
frequency_typeintThe 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_intervalintThe value to apply to the frequency set by frequency_type.
frequency_relative_intervalintThe date of the Distribution Agent:

 1 = First.

 2 = Second.

 4 = Third.

 8 = Fourth.

 16 = Last.
frequency_recurrence_factorintThe recurrence factor used by frequency_type.
frequency_subdayintHow often to reschedule during the defined period:

 1 = Once.

 2 = Second.

 4 = Minute.

 8 = Hour.
frequency_subday_intervalintThe interval for frequency_subday.
active_start_time_of_dayintThe time of day when the Distribution Agent will first be scheduled, formatted as HHMMSS.
active_end_time_of_dayintThe time of day when the Distribution Agent will stop being scheduled, formatted as HHMMSS.
active_start_dateintThe date when the Distribution Agent will first be scheduled, formatted as YYYYMMDD.
active_end_dateintThe date when the Distribution Agent will stop being scheduled, formatted as YYYYMMDD.

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

Community Additions

ADD
Show:
© 2016 Microsoft