Skip to main content
Pentaho Documentation

Quartz Cron Attributes

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 doesn't 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 # character to indicate a certain instance of a day of the month, for instance 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.

Attribute Conditionals 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