how to get the task end notification of service request

[Abilash]

In our Org,we have tickets with start date and end dates,so our requirement is to get the notification of ticket end date before 48hr,so it is possible to get the notification . 

[Piotr Smialek]

you can totally do this using a Scheduled trigger in Jira Automation.

Instead of waiting for an update, Jira will just scan your tickets every morning to see what's due.

here’s the setup:

Trigger: Set it to Scheduled (e.g., every day at 8:00 AM).

JQL Filter: Use this to find the right tickets: "End date" >= 47h AND "End date" <= 49h AND statusCategory != Done
(This ensures you catch everything hitting that 48h mark without spamming finished tasks).

Action: Add a Send email or Slack notification action. You can use "Smart Values" like {{issue.key}}

[Abilash]

Hi  ,Thanks for the reply.
can be done for a particular service request? while doing getting this error and used JQL : project = "YourProjectKey" AND issuetype = "Service Request" AND endDate >= startOfDay(+2d) AND endDate < startOfDay(+3d)....please help me on this.

[Piotr Smialek]

try this: "End date" >= 47h AND "End date" <= 49h AND statusCategory != Done

[Abilash]

after changing also getting same error

[Piotr Smialek]

are there any details below jql input field about warning?

[Arkadiusz Wroblewski]

@Abilash 

The first thing I would check is the field name.
If this is a custom field like End date, use the exact field name in quotes, for example:

project = ABC AND "End date" >= startOfDay(+2d) AND "End date" < startOfDay(+3d) AND statusCategory != Done

I would also avoid issuetype = "Service Request" unless that is really your Jira issue type. In JSM, “Service Request” is often the request type, not the issue type. Remember that.

[Abilash]

tried with both options, getting the same error, where I use the actual end field in the service request. 

[Piotr Smialek]

you have space added after end word  "Actual end " 

[Abilash]

Checked, and the same error is getting. Let me know exactly where I am missing it. If you are done from your end, please share the step-by-step process if possible.

[Piotr Smialek]

hmm no idea what is the problem :( im not good at permissions schemes but maybe there is a direction you should check

[Benjamin]

Hi @Abilash ,

@Piotr Smialek provided a great solution. The only thing I would add is to have an action to comment in the ticket to remind the user that there's 48hrs left before the due date and to please follow up. Once you @at mention the assignee, they will also get an notification as well. This help to put a note in the email and notified the ticket owner. 

[Arkadiusz Wroblewski]

Hello @Abilash 

That is possible with Automation.

For this use case, I would use a Scheduled rule that checks tickets whose End date is coming up in the next 48 hours, and then sends the notification before the deadline.

So the approach is basically: run the rule on a schedule, filter the relevant requests with JQL, and then send the email or other notification action.

That's pretty much standard use case.