Automatic change notification to the Change Assignee

[Jatin Masiwal]

Dear Team,

Need your support for the following scenario:

I would like to trigger a notification towards the change assignee before the change planned start time and the same type of notification after changed planned end time.

9 Am one day before the Change planned start date/time. 

9 Am one day after the Change planned end date/time.

I have custom field with name change planned start and end date/time under Change management.

Thanks in advance

Regards,
Jatin

[Adrián García González · Accepted solution]

Hi @Jatin Masiwal,

The easiest way to achieve what you need is with two automation rules that have a scheduled trigger. So both would run every day at 09AM and one would check if there are any issues planned for the next day and the other if there are any from the previous day, then both would send an email to the issue's Assignee.
Here is an example of how the rule should look like:

I hope you find it helpful, best regards!

[Jatin Masiwal]

Thanks @Adrián García González for your response. I would try the same in my Jira system. As I am not so good with JQL queries can you please tell both queries that can be used.

I assume for change Planned Start:

"Change planned Start">=now() and "Change planned Start"<= endOfDay(1)

and for change Planned End

"Change planned End">=now() and "Change planned End"<= endOfDay(-1)

Please let me know if those are correct or something has to be changed.

Regards,
Jatin

[Adrián García González]

Sorry, I didn't put the second JQL, it would be something like this:

"Change planned End" >= startOfDay(-1d) and "Change planned End" <= now()

Best regards!

[Jatin Masiwal]

Thanks a lot for your help. Highly Appreciated.