Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

Creating a Schedule with the Schedule Wizard

For convenience, you can use the
Schedule
wizard to create a schedule.
  1. On the
    Server Manager
    tab >
    Schedules
    view, click the
    Wizard
    icon button on the Schedules toolbar to start the
    Schedule
    wizard.
  2. On the
    Schedule Type
    page, select one of the following execution schemes:
    • Sequential
      . This execution scheme defines one schedule that runs the Extractor, transmits the intermediate file, and runs the Applier sequentially.
    • Parallel
      . This execution scheme defines two schedules that run independently. The first schedule runs the Extractor and transmits the intermediate file. The second schedule transmits the intermediate file and runs the Applier.
    • Continuous
      . This execution scheme defines one schedule that runs the Extractor, transmits the intermediate file, and runs the Applier for continuous replication.
  3. Click
    Next
    .
    If you selected the
    Sequential
    or
    Continuous
    execution scheme, the
    Schedule Configuration
    page appears.
    Schedule Configuration page on the Schedule Wizard
    If you selected the
    Parallel
    execution scheme, the
    Extractor Schedule Configuration
    page appears and the following schedule options in steps 4 to 10 apply to the Extractor and Send File tasks.
  4. In the
    Schedule name
    field, enter a unique and descriptive name for the schedule.
    Schedule names can contain only the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character. The Data Replication Console truncates schedule names that are longer than 100 characters.
  5. In the
    Owner
    list, select a schedule owner.
  6. Select
    Enable schedule
    check box to activate the schedule.
  7. For the
    Sequential
    and
    Parallel
    execution schemes only, perform the following substeps:
    1. Specify the frequency of execution under
      Every
      .
      You can enter a number of seconds, minutes, hours, days, or weeks.
    2. In the
      Maximum consecutive failures
      field, specify the maximum number of consecutive times that a schedule can end with an error before the Server Manager disables the schedule.
      To allow an unlimited number of consecutive schedule failures, enter 0.
  8. In the
    Schedule starts
    and
    Schedule ends
    fields, define the period during which the schedule runs. Click in each field to display a control for setting the date.
    For continuous replication, you can define a very long period, up to December 31, 2037.
  9. Under
    Runs daily from
    , define the start time and end time for the schedule run.
  10. Under
    Days of the week
    , select one or more days of the week on which the tasks run.
  11. For the
    Parallel
    execution scheme only, click
    Next
    and enter the schedule options for the Send File and Applier tasks.
  12. Click
    Next
    .
    The
    Replication Configuration
    page appears.
  13. Select a configuration and click
    Next
    .
    The wizard generates the schedule.
  14. Click
    Finish
    .
    The
    Schedules
    view displays the schedule in the list of schedules and scheduled tasks.
    If you observe Daylight Savings Time, restart the Server Manager after each time change to ensure that the Data Replication Console displays the accurate time.
    The schedule will run based on the scheduling options you set.
  15. If you want to start the schedule and run its tasks immediately, click the
    Start
    icon button on the Schedules toolbar, or right-click the schedule row and click
    Start
    .
    The
    Processes
    box lists target processes for the task.

0 COMMENTS

We’d like to hear from you!