Send notification 1 hour before SLA breaches

dhathrianoop · ‎12-18-2019

I want to send an email to the assigned group 1 hour before SLA breaches.

AbhishekGardade · ‎12-18-2019

No, we cant define conditions directly in notification because notification can be triggered When event is fired or record is inserted or updated.

What you need to do is, you need Create a event(sla.breach.one.hour.before) on task_sla table in event registry and trigger it from run script activity before one hour as below

var breachTime = current.planned_end_time ;

gs.log("breachTime: "+breachTime);

var gdt = new GlideDateTime(breachTime);

gdt.addSeconds(-3600);

gs.log("reminder date:"+gdt);

gs.eventQueueScheduled ("sla.breach.one.hour.before" , current , gs.getUserID(), gs.getUserName(), gdt);

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

Thank you,
Abhishek Gardade

View solution in original post

dhathrianoop · ‎12-18-2019

If 50% is less than an hour, I attached it directly and I'm getting the mail.

Thank you

AbhishekGardade · ‎12-18-2019

Great!!! Glad that worked.

Thank you,
Abhishek Gardade

sukran · ‎02-24-2020

Hi Abhishek

we have similar requirement that need to send a alert before 30 mins for planned date in change management

So how we can query this ? and write the scheduled job script ? on which condition >

Amol Pawar · ‎06-27-2023

Hi @AbhishekGardade ,

Could you please explain where do we need to add the above script?

I mean in email script or anywhere else?

Thanks,

Amol

Sanket Khabiya · ‎12-18-2019

Add Notification Activity right after the timer activity, which will trigger the notification.

Regards,

Sanket