Creating a Cron Expression Schedule
A cron expression is a string of five fields separated by a blank space.
Enter the cron expression in the following format:
<minute> <hour> <days of month> <months> <days of week>
Following are the valid field values that you can use in the cron expression:
-
<minute>: 0–59 -
<hour>: 0–23 -
<days of month>: 1–31 -
<months>: 1–12 (for January to December) -
<days of week>: 1–7 (for Monday to Sunday)
For example, to run the schedule at 23:00 on the 15th day of any month, enter this expression: 0 23 15 * *
A field can also have the following special characters:
-
*: Represents any value. -
,: Separator for more than one value. For example, for<days of week>,2,3represents Tuesday and Wednesday. -
-: Range of values. For example, for<days of week>,1-3represents Monday through Wednesday. -
/: Step values. For example, for<minute>,*/30represents every 30 minutes.
You can't create a schedule that triggers at an interval of less than 30 minutes. Only intervals of 30 minutes or more are allowed.
For example, you can create a schedule with the expression */30 * 15 * * to run the schedule every 30 minutes on the 15th day of any month. You can't, however, define a schedule with */15 * 15 * *.
Use the following procedure to create a schedule by writing a cron expression.
Use the oci data-integration schedule create command, required parameters, and the complex type parameter to create a schedule:
oci data-integration schedule create [OPTIONS]For a complete list of flags and variable options for CLI commands, see the Command Line Reference.
Run the CreateSchedule operation with the appropriate frequency model to create a schedule.