Modeling Guide for SAP Data Hub

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 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 a minute. Permitted: 0 to 59

Hour

Representation for an hour. Permitted: 0 to 23

DayOfMonth

Day of the month. Permitted: 1 to 31

Month

Numeric representation for month. Permitted: 1 to 12

DayOfWeek

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

Cron Syntax

The table provides the syntax that the application 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)

a,b,c

Anywhere

a or b or c

Cron Expression: Examples

The table lists some examples of cron expressions that you can use.

Expression

Description

* * * * *

Run the schedule every minute.

For this cron expression, the pipeline engine sets the graph to Run Always mode. In this scenario, the pipeline engine always checks if a graph is in running state, if it is not running, it attempts to run the graph.

*/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.