Schedule [Adapter Name] Job

The help for this page includes descriptions for core fields, actions, and buttons only.

Butons

Button Description

Basic/Advanced

Toggles between the Schedule [Job Name] Job—Basic page or the Schedule [Job Name] Job—Advanced page set of options.

The basic page allows you to create a job schedule based only on the days of the week and time.

The advanced page allows you to create a more detailed job schedule based on months, days, and time.

Fields (basic)

Field Available values Description
Days of the week
  • Sunday
  • Monday
  • Tuesday
  • Wednesday
  • Thursday
  • Friday
  • Saturday
  • All
Indicates that the job queue runs on the selected days.
Time span
  • Every minute
  • Every 5 minutes
  • Every 15 minutes
  • Every 30 minutes
  • No time span
Indicates that the job queue runs every number of minutes in the selected hours.

Note:

Oracle recommends setting the job queue to run every 15 minutes or higher.
Hours
  • 12 to 11 A.M.
  • 12 to 11 P.M.
  • All
Indicates the hours on the selected days on which the job queue runs.

Fields (advanced)

Field Available values Description
Months
  • January to December
  • All

Indicates the months on which the job queue runs.

Days
  • 1 to 31
  • All

Indicates the days of the month on which the job queue runs.

Time span
  • Every minute
  • Every 5 minutes
  • Every 15 minutes
  • Every 30 minutes
  • Custom

Indicates that the job queue runs at the specified interval in the selected hours.

For Custom, enter the desired value. The text must be a single value or a comma-separated list of values in the following format:

  • Time (24-hour clock) to start the queue, in HH:MM format.
  • A dash (-).
  • Time (24-hour clock) to stop the queue, in HH:MM format.
  • The number of minutes between the last time that the queue was processed and the next time that it should be processed, as a positive integer in square brackets ([,]).

    If the stop time is less than the start time, the stop time occurs on the day after the start time. If the start time and the stop time are the same, the time span is exactly 24 hours.

Examples:

  • 12:30-13:15[5]

    Process the queue every five minutes from 12:30 PM until 1:15 PM.

  • 23:30-3:45[10], 5:15-7:59[20]

    Process the queue every 10 minutes from 11:30 PM until 3:45 AM as well as every 20 minutes from 5:15 AM until 7:59 AM.

    If time spans contain some period of time in common or overlap, and the current time matches the pattern defined in either time span, the queue will be processed.

    Example:

    7:00-13:00[4],12:00-14:00[9]

    Processes the query every day at 3 AM, every 15 minutes between 12:45 AM and 1:15 AM, and every 30 minutes between 1:00 AM and 1:15 PM.

    Between noon and 1:00 PM, processes the queue if it has been a multiple of four minutes since 7:00 AM or a multiple of nine minutes since noon.

Note:

Oracle recommends setting the job queue to run every 15 minutes or higher.
Hours
  • 12 to 11 A.M.
  • 12 to 11 P.M.
  • All

Indicates the hours on the selected days on which the job queue runs.

Minutes
  • 0 to 59
  • All

Indicates the minutes when the job queue runs in the selected hours.