Table of Contents Previous Next


7 Common Operations : 7.2 Creating a Schedule

A schedule establishes recurring points in time when replication is to occur.
Note (For MMR only): Be sure an initial snapshot replication has been performed from the master definition node to every other master node in the multi-master replication system. If a newly added master node did not undergo an initial snapshot, any subsequent synchronization replication initiated by a schedule may fail to apply the transactions to that master node. The initial snapshot could be taken when the master node is first added (see Section 6.3) or by performing an on demand snapshot (see Section 6.5.1).
See Section 7.3 for changing or removing a schedule.
Step 1 (For SMR only): Select the Subscription node of the subscription for which you wish to create a schedule.
Step 1 (For MMR only): Select the Publication Database node designated as the controller database. (The Controller database field in the Property window is set to Yes for the controller database.)
Step 2 (For SMR only): Open the Scheduled Task Wizard dialog box in any of the following ways:
Step 2 (For MMR only): Open the Scheduled Task Wizard dialog box in any of the following ways:
Step 3: In the Scheduled Task Wizard dialog box, select the radio button for either synchronization replication or snapshot replication.
Note: If the publication associated with this subscription is a snapshot-only publication, then only Snapshot may be chosen.
Note: In a multi-master replication system, only Synchronize may be chosen.
Step 4: Select the radio button for the scheduled replication frequency, or select Cron Expression to write your own cron expression. The frequency choices have the following meanings:
Continuously. Schedules replication to run continuously at an interval in seconds that you specify. Select this option if the source tables change frequently during the day and the target tables must be kept up-to-date throughout the course of the day.
Daily. Schedules replication to run once a day at the time you choose. Select this option if the target tables need to be refreshed daily.
Weekly. Schedules replication to run once a day at the time you choose, but only on the specific days of the week you choose. Select this option if you need more flexibility than a daily schedule, and the target tables do not have to be refreshed every day.
Monthly. Schedules replication to run one day per month on the day of the month and time you choose, but only on the specific months you choose. Select this option if updates to the source tables are not very frequent, and the target tables can be out-of-date by a month or more. The Monthly option allows you to schedule replication for as frequently as once a month or infrequently as once a year.
Cron Expression. Provides additional flexibility for specifying a schedule beyond the four preceding radio button choices. See appendix Section 10.4.3 for directions on writing a cron expression.
Step 5: After completing the Scheduled Task Wizard dialog box, click the Next button.
Step 6: Your selected schedule will appear. Click the Finish button to accept the schedule.

7 Common Operations : 7.2 Creating a Schedule

Table of Contents Previous Next