In Jira Automation - my cron expression is getting undesirable results

[Adam LaCoste]

Can someone help with the Jira Automation to schedule ticket creation using cron expression.  Here are the details:

• Create a ticket the first Sunday of March, June, September and December

0 0 0 ? 3,6,9,12 1#1 *

The Next Run window shows that the schedule will run every Friday of every week.

[Gor Greyan · Accepted solution]

Hi @Adam LaCoste

Try this, crone.

0 0 9 ? MAR,JUN,SEP,DEC SUN *

[Trudy Claspill]

@Gor Greyan 

Your cron statement would not limit the schedule to the first Sunday of each month, which the author stated as a requirement.

• Create a ticket the first Sunday of March, June, September and December

Your cron would run on every Sunday.

You can find online cron generator/validators, such as https://crontab.cronhub.io/

[Gor Greyan]

Hi @Trudy Claspill

Thanks for reminding, I didn't notice the "first" part.

Thanks for the source, but I am using another one, which is more better for me.

@Adam LaCoste

You can try using the following one.

0 0 9 ? MAR,JUN,SEP,DEC 1#1 *

For testing, I suggest using this, to see if it runs in the 3-rd Sunday of July. if yes, I think the provided one will work for your purpose.

0 0 0 ? JUL 1#3 *

[Trudy Claspill · Accepted solution]

Hello @Adam LaCoste 

Are you referring to the Next Run information that shows when you look at the Basic tab of the Scheduled trigger configuration? I believe that information is being shown based on the Basic settings that are selected, not based on the Cron specified in the Advanced tab.

You may notice that the Scheduled trigger in the flow on the left shows the schedule based on which tab you have selected:

You need to save/publish the rule with the Advanced tab selected in order for the Cron to be used as the rule schedule.

And there is no display in the Advanced tab of the next run time.

[Adam LaCoste]

Thanks Trudy.  I think that is what was tripping me up.  I will continue testing.

Adam L

[John Funk · Accepted solution]

Hi Adam,

Try this: 

0 0 0 ? MAR,JUN,SEP,DEC 1#1 *

[Adam LaCoste]

Thanks John, same results.

[John Funk]

So you are just basing that on the next run? I don't think that considers CRON runs - just the basic info. You will know soon enough as to whether it runs next Friday or not. The other option is to change it to Saturday and see if it runs tomorrow. 

[John Funk]

So, I assume that this did not run on Friday - correct? 

[Adam LaCoste]

Thanks John.  I think I was getting confused by the "Next 10 Runs" expecting the display to reflect the changes made on the Advanced tab.

I will continue to test.

Adam