Is there a way to automate the reminder 1 day before sprint closure?

[Dheeraj Kumar C]

Hi All,

I need some help to prepare the JQL query or any other way to automate and send the reminder to the team members 1 or 2 days before the automated sprint closure.

Thanks in advance,

Dheeraj

[arielei · Accepted solution]

Hey @Dheeraj Kumar C 

You can achieve this by creating the following automation:

Trigger - Schedule to run every day with JQL condition : sprint in openSprints()

If Smart value : {{now.diff(sprint.last.endDate).businessDays}} equals 2

Action: Send email or Slack or teams (depending on what method you want).

Best regards,

Ariel

[Dheeraj Kumar C]

Thank you @arielei  for the response :)

[Bill Sheboy · Accepted solution]

Hi @Dheeraj Kumar C -- Welcome to the Atlassian Community!

As a variation of the suggestion from @arielei please consider checking the maximum date rather than the last sprint added to an issue.  This will prevent problems with re-ordering of sprints in the backlog causing mismatches.

And, the bulk-handling feature must be used with the scheduled trigger with JQL and the openSprints() function for this scenario. Otherwise, the rule would send the reminder for each issue in the open sprint.

For example:

• trigger: Scheduled, to run daily early in the morning, with JQL
  • project = myProject AND sprint IN openSprints()
  • select the option "Process all issues produced by this trigger in bulk"
• advanced compare condition
  • first value: {{now.diff(issues.first.sprint.endDate.max).businessDays}}
  • condition: equals
  • second value: 2
• action: send the reminder email

Please note well the plural smart value {{issues}} is used with the bulk-handling feature, but we only need to check one issue, such as the first one from the trigger.

Kind regards,
Bill

[Dheeraj Kumar C]

Thank you @Bill Sheboy for the response.

[Benjamin Anderson]

You can use Jira Automation → Scheduled rule: run daily with JQL sprint in openSprints() and add an email/Slack action. Schedule it 1–2 days before sprint end. JQL alone can’t trigger reminders.