Differences

This shows you the differences between two versions of the page.

Link to this comparison view

72:custom_reports_references_crontriggers_expression [2019/03/08 19:53]
ext-bkkr created
72:custom_reports_references_crontriggers_expression [2019/03/08 19:56] (current)
ext-bkkr
Line 7: Line 7:
 ^Field Name^Allowed Values^Allowed Special Characters| ^Field Name^Allowed Values^Allowed Special Characters|
 |Seconds|0-59|,​ - * /| |Seconds|0-59|,​ - * /|
-|Minutes|0-59|,​ - * / | +|Minutes|0-59|,​ - * /| 
-|Hours|0-23|,​ - * / |+|Hours|0-23|,​ - * /|
 |Day-of-Month|1-31|,​ - * ? / L W| |Day-of-Month|1-31|,​ - * ? / L W|
 |Month|1-12 or JAN-DEC|, - * /| |Month|1-12 or JAN-DEC|, - * /|
Line 16: Line 16:
 The '​*'​ character is used to specify all values. For example, "​*"​ in the minute field means "every minute"​. The '​*'​ character is used to specify all values. For example, "​*"​ in the minute field means "every minute"​.
  
-The '?'​ character is allowed for the day-of-month and day-of-week fields. It is used to specify 'no specific\\ +The '?'​ character is allowed for the day-of-month and day-of-week fields. It is used to specify 'no specific value'​. This is useful when you need to specify something in one of the two fields, but not the other.
-value'​. This is useful when you need to specify something in one of the two fields, but not the other.\\ +
-The '​-'​ character is used to specify ranges for example "​10-12"​ in the hour field means "the hours 10, 11 and\\ +
-12".+
  
-The ',' character is used to specify ​additional values. For example "MON,WED,FRI" in the day-of-week ​field\\ +The '-' character is used to specify ​ranges for example "10-12" in the hour field means "​the ​hours 1011 and 12".
-means "​the ​days Monday, Wednesday, and Friday".+
  
-The '/' character is used to specify ​increments. For example "0/15" in the seconds field means "the seconds\\ +The ',' character is used to specify ​additional values. For example "MON,WED,FRI" in the day-of-week ​field means "​the ​days MondayWednesday, and Friday"
-01530, and 45". And "5/15" in the seconds ​field means "​the ​seconds 520, 35, and 50". Specifying\\ +
-'​*'​ before the '/'​ is equivalent to specifying 0 is the value to start with. Essentially,​ for each field in the\\ +
-expression, there is a set of numbers that can be turned on or off. For seconds and minutes, the numbers\\ +
-range from 0 to 59. For hours 0 to 23, for days of the month 0 to 31, and for months 1 to 12. The "/"​ character\\ +
-simply helps you turn on every "​nth"​ value in the given set. Thus "​7/​6"​ in the month field only turns on month\\ +
-"​7",​ it does NOT mean every 6th month, please note that subtlety.+
  
-The 'L' character is allowed for the day-of-month and day-of-week fields. This character is short-hand for\\ +The '/' character is used to specify increments. For example "0/15" in the seconds ​field means "​the ​seconds 0, 1530, and 45"And "​5/​15" ​in the seconds ​field means "the seconds 5, 20, 35, and 50"​. ​Specifying '​*'​ before the '/'​ is equivalent to specifying 0 is the value to start with. Essentially,​ for each field in the expression, there is a set of numbers that can be turned on or off. For seconds and minutes, the numbers range from 0 to 59. For hours 0 to 23, for days of the month 0 to 31, and for months 1 to 12. The "/" ​character simply helps you turn on every "nth" value in the given set. Thus "​7/​6"​ in the month field only turns on month "7", it does NOT mean every 6th monthplease note that subtlety.
-"​last",​ but it has different meaning in each of the two fields. For example, the value "L" in the day-of-month\\ +
-field means "​the ​last day of the month" - day 31 for Januaryday 28 for February on non-leap yearsIf\\ +
-used in the day-of-week ​field by itself, it simply ​means "7" or "SAT"​. ​But if used in the day-of-week field\\ +
-after another valueit means "the last xxx day of the month" - for example ​"6L" ​means "​the ​last friday of\\ +
-the month". When using the '​L'​ option, it is important not to specify listsor ranges of values, as you'll get\\ +
-confusing results.+
  
-The 'W' character is allowed for the day-of-month ​field. This character is used to specify the weekday\\ +The 'L' character is allowed for the day-of-month ​and day-of-week fields. This character is short-hand for "​last",​ but it has different meaning in each of the two fieldsFor example, ​the value "L" ​in the day-of-month field means "​the ​last day of the month" ​- day 31 for Januaryday 28 for February ​on non-leap years. If used in the day-of-week field by itself, it simply means "​7"​ or "​SAT"​But if used in the day-of-week field after another valueit means "the last xxx day of the month" - for example "​6L"​ means "the last friday of the month"When using the 'L' ​optionit is important ​not to specify lists, ​or ranges ​of values, as you'll get confusing results.
-(Monday-Friday) nearest ​the given dayAs an example, ​if you were to specify ​"15W" ​as the value for the\\ +
-day-of-month field, the meaning is: "​the ​nearest weekday to the 15th of the month". So if the 15th is a\\ +
-Saturdaythe trigger will fire on Friday the 14th. If the 15th is a Sundaythe trigger will fire on Monday the\\ +
-16th. If the 15th is a Tuesday, then it will fire on Tuesday the 15thHowever ​if you specify "​1W"​ as the value\\ +
-for day-of-monthand the 1st is a Saturday, ​the trigger will fire on Monday ​the 3rd, as it will not '​jump'​ over\\ +
-the boundary of a month's daysThe 'W' ​character can only be specified when the day-of-month is a single\\ +
-day, not a range or list of days.+
  
-\\ +The '​W' ​character is allowed ​for the day-of-month ​field. This character is used to specify the weekday (Monday-Friday) nearest the given day. As an exampleif you were to specify ​"15W" as the value for the day-of-month field, the meaning is: "the nearest ​weekday ​to the 15th of the month". So if the 15th is a Saturday, the trigger will fire on Friday the 14th. If the 15th is a Sunday, the trigger will fire on Monday the 16th. If the 15th is a Tuesday, then it will fire on Tuesday the 15th. However if you specify "​1W"​ as the value for day-of-month,​ and the 1st is a Saturday, the trigger will fire on Monday the 3rd, as it will not '​jump'​ over the boundary of a month'​s days. The '​W'​ character can only be specified when the day-of-month is a single day, not a range or list of days.
-The '​L'​ and '​W' ​characters can also be combined ​for the day-of-month ​expression ​to yield '​LW'​which\\ +
-translates ​to "last weekday of the month"​.+
  
-The '#'​ character is allowed for the day-of-week field. This character is used to specify "the nth" XXX day of\\ +The '​L'​ and '​W'​ characters can also be combined for the day-of-month expression to yield '​LW',​ which translates to "last weekday of the month"​. 
-the month. For example, the value of "​6#​3"​ in the day-of-week field means the third Friday of the month (day\\ + 
-6 = Friday and "#​3"​ = the 3rd one in the month). Other examples: "​2#​1"​ = the first Monday of the month and\\ +The '#'​ character is allowed for the day-of-week field. This character is used to specify "the nth" XXX day of the month. For example, the value of "​6#​3"​ in the day-of-week field means the third Friday of the month (day 6 = Friday and "#​3"​ = the 3rd one in the month). Other examples: "​2#​1"​ = the first Monday of the month and "​4#​5"​ = the fifth Wednesday of the month. Note that if you specify "#​5"​ and there is not 5 of the given day-ofweek ​in the month, then no firing will occur that month.
-"​4#​5"​ = the fifth Wednesday of the month. Note that if you specify "#​5"​ and there is not 5 of the given day-of-week ​in the month, then no firing will occur that month.+
  
 The legal characters and the names of months and days of the week are not case sensitive. The legal characters and the names of months and days of the week are not case sensitive.