Spring Cron syntax

Cron is a software utility that specifies commands to run on a given schedule. This schedule is defined by a Cron pattern, which has a specific syntax that will be described in this section.

Warning If you create an invalid Cron pattern, Collibra Data Intelligence Cloud stops responding.

Note By default, Collibra Console uses Spring Cron expressions to schedule back-ups, while you use Quartz Cron expressions, for example, to schedule your mail, LDAP synchronizations, Purge cycles, Tableau and S3 synchronizations or to create a statistics cron map.

The Cron pattern consists of six space-separated fields:

<second> <minute> <hour> <day> <month> <weekday>

Position

Field

Description

1

second

This field determines the second of the schedule:

  • <second>: at the entered second. The value must be between 0 and 59, included.
  • */<second>: every <second> seconds. For example, */10 corresponds to every 10 seconds.

2

minute

This field determines the minute of the schedule:

  • minute: at the entered minute. The value must be between 0 and 59, included.
  • minute/minute: on the given minutes, values included. For example, 15/45 corresponds to every hour at 15 and 45 minutes past the hour.
  • */minute: every <minute> minutes. For example, */15 corresponds to every 15 minutes.

3

hour

This field determines the hour of the schedule:

  • hour: at the entered hour. The value must be between 0 and 23 included.
  • hour-hour: range of hours, values included. For example, 8-10 means at 8,9 and 10 o'clock.
  • hour,hour: at the given hours. For example, 6,18 means at 6 AM and at 6 PM.

4

day of the month

This field determines the day of the schedule:

  • day: at the entered day of the month. The value must be between 1 and 31 included.
  • day-day: range of days of the month, values included. For example, 1-4 corresponds to every first four days of the month.
  • day,day: at the given days of the month. For example, 1,15 corresponds to the first day of the month and the 15th day of the month.

5

month

This field determines the month of the schedule:

  • month: at the entered month of the year. The value must be between 1 and 12, included. You can also use the first three characters of the English names, JAN, FEB, MAR and so on.
  • month-month: range of months, values included. For example, 1-3 corresponds to every first three months of the year.
  • month,month: at the given months of the year. For example, APR,AUG,DEC corresponds to every April, August and December of the year.

6

day of the week

This field determines the day of the week of the schedule:

  • day of the week: at the entered day of the week. The value must be between 1 and 7, included, respectively corresponding to Sunday and Saturday. You can also use the first three characters of the English names, MON, TUE, WED and so on.
  • day of the week-day of the week: range of days of the week, values included. For example, 2-6 corresponds to Monday to Friday.
  • day of the week,day of the week: on the given days of the week. For example, MON,WED,FRI corresponds to every Monday, Wednesday and Friday.

For more information, see the Spring Cron documentation.

Non-standard characters

  • asterisk (*): Used to select all values within a field. For example, "*" in the minute field corresponds with every minute.
  • question mark (?): Used to specify something in one of the two fields in which the character is allowed, but not the other, mainly used for weekdays. For example, if you want your trigger to fire on a particular day of the month, for example the 10th, but don't care what day of the week that happens to be, you could put "10" in the day-of-month field, and "?" in the weekday field.
Example 
  • 0 0 * * * * = the top of every hour of every day.
  • */10 * * * * * = every ten seconds.
  • 0 0 8-10 * * * = 8, 9 and 10 o'clock of every day.
  • 0 0 6,19 * * * = 6:00 AM and 7:00 PM every day.
  • 0 0/30 8-10 * * * = 8:00, 8:30, 9:00, 9:30, 10:00 and 10:30 every day.
  • 0 0 9-17 * * MON-FRI= on the hour nine-to-five weekdays.
  • 0 0 0 25 12 ?= every Christmas Day at midnight, no matter what weekday it is.