How to Exclude Holidays from a Scheduled Trigger Rule?

Question

Hi everyone,

I’ve created a rule with a ‘Scheduled’ trigger to run on all working days. However, I want it to exclude holidays.

I’ve added next Monday as a holiday in the board, but the rule still shows that day as scheduled. Am I missing a step to ensure holidays are excluded?

Any guidance would be appreciated!

Trudy P Claspill · Accepted Answer

The Schedule component of an automation rule schedule does not take into consideration holidays. It is purely a CRON function looking at the date/time of the Jira system.

If you want it to not execute actions on specified dates you will have to add a Condition after the trigger to ensure the current date is not one of your holiday dates.

There is not an Automation function to look at holidays you have defined in another Jira feature. You would need to explore the Jira REST API to see if that information could be obtained through an API call.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/intro/#about

https://docs.atlassian.com/jira-software/REST/7.0.4/

Bill Sheboy · Accepted Answer

Hi @Tharaka_Hettiarachchi

Unfortunately there is no way to get the configured non-working days for a board yet.  Here is a suggestion to add that feature to the REST API: https://jira.atlassian.com/browse/JSWCLOUD-23009

As a workaround, you could use the condition test @Trudy P Claspill describes, with these possible sources for the holiday list:

* use a Lookup Table: https://community.atlassian.com/t5/Automation-articles/Update-Create-lookup-table-action-improvements/ba-p/2427798
* store the dates in a CSV file as an attachment within a specific issue, and use the REST API to load and then parse the dates for testing
* use an entity property stored at the project level to hold the dates
* build your own API endpoint to return / test the dates that could be called with the Send Web Request action

Kind regards,
Bill