Skip to main content
Pentaho Documentation

Quartz Cron Attributes

Parent article

The Quartz cron engine supports a seven-attribute time declaration with many possible values. The number format is the same for every expression, even if the values are different: it must be listed as seconds, minutes, hours, day of month, month, day of week, then the year. A space separates each attribute.

These are the possible values for each attribute: 0 to 59 for seconds and minutes, 0 to 23 for hours, 1 to 31 for days, 1 to 12 for months, 1 to 7 for day of week, and a four-digit year. Alternatively, you can use three-letter values for the day of week (MON, TUE, WED, THU, FRI, SAT, SUN), and three-letter values for the month (JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC).

An Asterisk (*) indicates "all values," so an asterisk in the minute field would mean that the report runs once every minute. You can specify a range of values with the Dash (-) operator, and you can specify multiple individual values with a comma. If you need to excuse a value in the day of month and day of week field from a cron job, you can use the Question Mark (?) character to indicate that this value does not matter. If you need to split values, you can do so with the Slash (/) character: this operator literally means "every," so */15 would mean "Every 15." In the day of month field, you can use the Hashtag (#) character to indicate a certain instance of a day of the month. For example, the second Friday of the month would be 6#2.

Lastly, you can use a capital L in the day of month and day of week field to indicate "Last," as in the last day of the week. A capital C in either of these fields means "Calendar," and combined with a number means that the report should execute a the interval indicated by the C number according to the loaded calendar. A capital W in the day of month attribute means "Weekday," which only encompasses Monday through Friday. Most of these values can be combined to create unusual cron schedules.

AttributeConditionals and Operators
Seconds, - * /
Minutes, - * /
Hours, - * /
Day of month, - * ? / L W C
Month, - * /
Day of week, - * ? / L C #
Year, - * /

Here is how you would execute a report at 10:15 AM on every last Friday of every month during the years 2008, 2009, 2010, 2011, 2012, and 2013.

0 15 10 ? * 6L 2008-2013