How to Exclude Holidays from a Scheduled Trigger Rule?

[Tharaka_Hettiarachchi]

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!

[Bill Sheboy · Accepted solution]

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

[Tharaka_Hettiarachchi]

Thank You

[Trudy Claspill · Accepted solution]

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/

[Tharaka_Hettiarachchi]

Thank You