Modeling Guide

Cron Expression Format

Use cron expressions to define the recurrence condition that the tool must use to schedule the graph execution.

Cron Format

Cron expression to execute graphs in the SAP Data Hub Modeler is a string comprising of five fields. The table lists the order of fields (from left to right) in a cron expression and the permitted values for each field.

Cron Field (from left to right)

Description

Minute

Representation for minute. Permitted: 0 to 59

Hour

Representation for hour. Permitted: 0 to 23

DayOfMonth

Day of month. Permitted: 1 to 31

Month

Numeric representation for month. Permitted: 1 to 12

DayOfWeek

3-letter representation for day of week. Permitted: mon, tue, wed, thu, fri, sat, sun

Cron Syntax

The table illustrates the syntax that the tool supports to define a cron expression.

Expression

Where Used

Value

.

Anywhere

Any value

*/a

Anywhere

Any a-th value

a:b

Anywhere

Values in range a to b

a:b/c

Anywhere

Every c-th value between a and b

a.y

DayOfWeek

On the a-th occurrence of the weekday y (a = 0 to 6) On the a-th occurrence of the weekday y (a = 0 to 6)

a,b,c

Anywhere

a or b or c

Cron Expression: Examples

The table lists some examples for creating a valid cron expression and its meaning

Expression

Description

* * * * *

Run the schedule every minute

*/5 13 * 12 0

Run the schedule every 5th minute between 1:00 PM (UTC) and 1:59 PM (UTC) on Sundays in December.

* * -1.sun 9 0

Run the schedule on the last Sunday of every month at 09:00.