Oracle Cloud Infrastructure Documentation

Creating a Task Schedule

Create a task schedule in Data Integration for the task that you want to run on an automated schedule.

You create a task schedule to run the task on specific days and times, and at a specific frequency. A task schedule must be associated with an existing schedule. You can enable or disable a task schedule at any time.

The run options that you can define for a task schedule are as follows:

  • The execution start date and time, and the end date and time. Enter a specific end time and date if you want a scheduled task run to continue beyond the default end date, which is three months from the creation date of a task schedule.
  • The estimated time for a run to finish.
  • The number of times to retry a run when a run fails.
  • The length of time to wait before retrying.

By default, Data Integration allows simultaneous or parallel task runs of a task at a given time. To disallow concurrent task runs by a task schedule, select the disable simultaneous execution checkbox when you create the task schedule. When the checkbox is selected, any scheduled running of the task by the task schedule is skipped if the scheduled task run that's previously triggered is still running.

    1. On the workspace home page, click Applications.
    2. On the Applications page, select the compartment that contains the application.
    3. In the applications list, click the name of the application that contains the task that you want to schedule.
    4. On the application details page, click Tasks.
    5. In the tasks list, select Schedule from the Actions menu of the task that you want to run on an automated schedule.
    6. On the Create task schedule page, enter a name and a description (optional).

      The identifier is a system-generated value based on the name. You can change the value, but after you create and save the task schedule, you can't update the identifier.

    7. Select the Enable task schedule check box to allow this task schedule to trigger automated runs when schedule conditions are met.
    8. Select the Disable simultaneous execution of the task via the schedule check box if you want to disallow concurrent runs of the task by the task schedule.
    9. In the Schedule section, click Select to associate this task schedule with a schedule.
    10. On the Select schedule page, perform one of the following actions, and then click Select.
      • Select an existing schedule in the application.
      • Click Create schedule to create a schedule and then select the new schedule. See Creating a Schedule if you need help.
    11. On the Create task schedule page, in the Configure task schedule section, click Configure to specify run options for this task schedule.
      1. (Optional) For Start time, click the calendar icon to specify a date and time for this task schedule to start. If you don't specify a start time, this task schedule takes effect immediately, and runs are triggered when conditions specified in the associated schedule are met.
      2. For End time, click the calendar icon to specify an end date and time.

        The specified end date and time can't be in the past.

        The default end date is three months from the current creation date of this task schedule. If you don't enter a specific end date and time, scheduled task runs don't run beyond the default end date.

      3. (Optional) For Expected time to complete, enter a value and select a unit from the menu to specify the time it takes for a run to finish. You can specify a value in seconds, minutes, hours, or days.

        When a task run exceeds this expected time, Data Integration generates a notification event without stopping the run. The task continues to run until the run finishes or fails.

      4. For Retry count, enter the number of times to retry running the task when a run fails.
      5. For Retry delay duration, enter a value and select a unit from the menu to specify the time interval between retries. You can specify a value in seconds, minutes, or hours. The value must be greater than 5 seconds.
      6. Click Configure.
    12. (Optional) If a task uses parameters, you can perform the following actions on the Create task schedule page:
      1. In the Configure parameters section, click Configure to view or change the default parameter values to use at runtime.
      2. On the Configure Parameters page, click Edit next to a parameter value that you want to change.

        Consider the following restrictions:

        • If the incremental extract strategy for a BICC source is configured to use a date that's managed by the Data Integration system parameter SYS.LAST_LOAD_DATE, you're not allowed to change the date value during design time.

        • If the incremental extract strategy for a BICC source is configured to use a parameterized last extract date that you have added, you can change the date value during design time and runtime.

        • If a parameterized target data entity is configured to use the Merge strategy, you can change the Merge key selection.

      3. In the Edit parameter panel, change the value and click Save.
      4. Repeat the preceding steps to change other parameter values.
      5. When done, click Configure to return to the Create task schedule page.
    13. (Optional) On the Create task schedule page, in the Validate section, click Validate to check for errors in configured parameter values.
    14. Click Create and close.

      When the task schedule is successfully created, Data Integration displays a notification message with a View details link. If you click the link, the details page of the new task schedule opens.

    The task schedule that you created is listed in the Task schedules section of the application details page. See Viewing Task Schedules.

    All the task schedules that are created for this task are listed in the Task schedules section of the task details page in the application. See Viewing a Task's Associated Task Schedules.

  • Use the oci data-integration task-schedule create command and required parameters to create a task schedule for a published task:

    oci data-integration task-schedule create [OPTIONS]

    For a complete list of flags and variable options for CLI commands, see the Command Line Reference.

  • Run the CreateTaskSchedule operation to create a task schedule for a published task.