How can I schedule a rule to run every 2 weeks on a particular day?

Nick Menere
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2017

When scheduling a rule, I can set an interval every 14 days but I can't set the day I want it to execute.

If I use a Cron expression to schedule, you can't specify every 2 weeks (every fortnight).

Is there a way to run the rule every 2 weeks on a Monday at 9am?

1 answer

1 accepted

3 votes
Answer accepted
Nick Menere
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2017

In order to do this, you will need to use Cron to run the rule every Monday at 9am and then use a condition to check that it is an even (or odd) week of the year.

Your trigger would like:

Screen Shot 2017-10-16 at 2.43.37 pm.png

You condition (the first thing after the trigger) will look like:

Screen Shot 2017-10-16 at 2.50.07 pm.png

What this is doing is:

  • Rendering the current week of the year
  • Finding the remainder when you divide it by 2
  • If this is 0, it must be an even week, otherwise it is an odd week.

The formulae is:

{{#=}}{{#now}}w{{/}} % 2{{/}}
oren.david November 10, 2019

@Nick Menere it didn't work to me, however this comparison works fine:

 

even week.png

It checks if the week number is even.

{{#=}}{{now.weekOfYear}}/2 - ROUND({{now.weekOfYear}}/2,0){{/}}
Diego Quesada August 3, 2020

Hi It doesn't work for me. Can ypu help me

oren.david August 5, 2020

@Diego Quesada the simple way to validate math expressions is to print them in a comment. For this I recommend to create a rule for tests (that you execute manually or something like that) and add an action to add comment to the issue.

Put the expression above in the comment and run the rule and see the results.

The week number today is even (week #32), so the result should be zero.

If you need more help please share printscreen.

Diego Quesada August 5, 2020

Will be like this?

2020-08-05 11_04_25-Automation rules - Jira.png

oren.david August 10, 2020

yes, now run the rule manually in an issue and see the results.

Like Soluciones TIC likes this

Suggest an answer

Log in or Sign up to answer