I want to create an automation rule that sends an email 6 months after closing

[Jason Selby]

I need to be able to create an automation rule that sends an email to a mailbox 26 weeks after closing a service request and was asking the community the best way to do this as the rule i created failed last time, any ideas would be welcomed....

[Guilhem Dupuy]

jj

Hi @Jason Selby ,

It tested something like this on my instance and it works :

For the trigger, you could use something like this, with the embedded jQL request : 

And then send an email to an address you specify, like on this example :

Let me know if it helps,

Guilhem

[Jason Selby]

Guilhem, can you send me the JQL you have used because i cannot get it to validate

[Guilhem Dupuy]

You could try this JQL : 

resolved > -27w AND resolved >= -26w

Or with this alternative JQL (for the same result) : 

resolutiondate > -27w AND resolutiondate >= -26w

[Daniel Vest]

@Guilhem Dupuy Thanks for posting this solution! This was a help to me today.

[Vahagn Beglaryan]

You can use cron expression to schedule the trigger.

[Vahagn Beglaryan]

JQL: status changed to closed before -25w after -27w

Cron: 0 0 10 ? * MON *

[Vahagn Beglaryan]

So it will be triggered every Monday on 10:00 AM, and include all issues that have been closed 26 weeks ago.