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 from the Server Manager Tab

Creating a Schedule from the Server Manager Tab

You can create a schedule for running the tasks that are defined on the
Server Manager
tab >
Tasks
view.
Within a schedule, you can include a particular task only once. Data Replication executes the task and ignores any additional occurrences of it in the schedule.
When you replicate data to multiple targets, the Applier, Send File, and InitialSync tasks contain multiple target processes, one for each target. Otherwise, a task contains a single target process.
You can create a schedule to run replication tasks with a particular configuration or to run tasks that do not require a configuration. You can create a schedule only for the configurations for which you are designated as the owner.
  1. On the
    Server Manager
    tab >
    Schedules
    view, click the
    New
    icon button on the Schedules toolbar.
    The
    New
    dialog box appears.
    New dialog box in the Schedules view on the Server Manager tab
  2. 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.
  3. In the
    Configuration
    list, select the configuration for the tasks that you are scheduling.
    Data Replication uses this information to generate a command to execute the tasks.
  4. In the
    Owner
    list, select a schedule owner.
  5. In the
    Keep logs for
    field, specify the number of days to retain the output logs from the scheduled Extractor, Applier, and other tasks.
  6. Select
    Enable schedule
    to activate the schedule.
  7. In the
    Run
    list, select the periodicity with which you want to run the scheduled tasks. Options are:
    • Periodically
      . Run the tasks periodically based on other settings such as the date and time at which a task starts and ends, the task run frequency, and days of the week.
    • On demand
      . Run the tasks one time.
    • Continuous
      . Perform continuous data replication. The tasks run continuously during the period that you specify in the
      Schedule starts
      and
      Schedule ends
      fields.
    Do not schedule an InitialSync task to run periodically or continuously.
  8. For a schedule that runs periodically, 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.
  9. 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.
  10. Under
    Days of the week
    , select one or more days of the week when the tasks run.
  11. Under
    Runs daily from
    , define the start and end times for the schedule run.
  12. Under the
    Referenced Tasks
    box, click the
    New
    icon button to add a task reference to the schedule.
    The
    New Task
    dialog box appears.
    The New Task dialog box contains a list of available tasks and the Run with task dependencies check box.
  13. Select a previously defined task from the list.
    You can add tasks for which another user is the owner.
  14. Select
    Run with task dependencies
    if the task depends on another task.
  15. Click
    OK
    .
    The task appears in the
    Referenced Tasks
    box.
    You can click the
    Delete
    icon button to remove a task.
  16. Repeat steps 12 through 15 to add additional tasks to the schedule.
  17. Click
    OK
    .
    The schedule and its tasks appear in the
    Schedules
    view.
    The following image shows an example view:
    The Schedules view shows the running continuous schedule ora2ora_demo.
    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.
  18. 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 shows the status of processes for the Extractor, Send File, Applier, and other tasks.

0 COMMENTS

We’d like to hear from you!