Email triggers by using Jira automation with cron expression

[Prabhu Chilukuri]

Hi Team

I want trigger a notification by using Jira automation, if the ticket Due date is exceeded more than 3 days(weekends should not be calculated).

Can you please assist me to create a CRON expression on above requirement?

Thanks,

Prabhu Ch

[Bill Sheboy · Accepted solution]

Hi @Prabhu Chilukuri 

For Jira automation scheduled rules, the trigger is based upon a time frequency and does not look at the details of the issues for the frequency.

Instead you decide the frequency to run the rule, and perhaps add JQL to supply the issues.

However, JQL does not have any built-in features for business days differences.  Your work-around options are:

• to investigate marketplace addons for JQL that add business day difference functions, or
• to test a larger range of issues with JQL (e.g. gather anything in the last week) and then use the smart value functions to perform the actual business days difference.

Please review the documentation for JQL and automation smart values for date/time to learn more about how to do this.

Kind regards,
Bill

[John Funk]

Hi Prabhu - I am marking this as Answer accepted since Bill's response should meet your need. If not, please post back with any additional problems you are encountering with implementing his suggestion.