Send an email 15 Minutes prior to Change planned start date/time

imran rasheed · ‎05-18-2020

Hi. I am trying to set up an email notification that will be sent to the assignee of a change 15 Minutes prior to the planned start date. To do this I've attempted to create a Scheduled Job that runs hourly, checks for records where the planned start date is 15 Minutes away and then creates an Event. The event should then trigger the email notification. However, I'm having trouble figuring out how to work out the '15 Minutes from now' part. When i filter it out, it shows all the upcoming changes. Not only the ones which is going to start in 15 minutes time.

This is my script in the Scheduled Job:

var gr = new GlideRecord('change_request');

gr.addActiveQuery('active', 'true'); //It will fetch all Active Records

gr.addEncodedQuery('start_dateRELATIVEGT@minute@ahead@15');

gr.query();

while(gr.next()) {

gs.eventQueue("change.remainder", gr, "", "");

}

asifnoor · ‎05-18-2020

Hi,

Try like this.

var gr = new GlideRecord('change_request');
gr.addActiveQuery('active', 'true'); //It will fetch all Active Records
gr.query();
while(gr.next()) {
var gdt = new GlideDateTime(gr.start_date);
gdt.addSeconds(-900);
var gdt1 = new GlideDateTime();
  if(gdt.equals(gdt1)) {
    gs.eventQueue("change.remainder", gr, "", "");
  }
}

Or , you can try another approach.

In the BR after insert, trigger a event like below.

var gdt = new GlideDateTime(current.start_date); //put actual field name
gdt.addSeconds(-900);
gs.eventQueueScheduled("change.remainder", current, "", "",gdt);

Kindly mark the comment as a correct answer and helpful if it helps to solve your problem.

Regards,
Asif
2020 ServiceNow Community MVP

View solution in original post

asifnoor · ‎05-20-2020

You need to run every minute, because there could be different change request with different start dates.

Report Inappropriate Content · ‎06-24-2022

Hi Asif,

Could you please share the code that you corrected/modified, so that it will be a help for all.

I have almost the same requirement and am referring to your code for some insights.

VR17 · ‎06-28-2023

Hi Imran,

I have a similar requirement, Can You share the script from your personal instance?

Sushant Kadam1 · ‎05-18-2020

Hi Imran,

can you try scheduling your job with the above first script approach after every 15 min?

Garimella Naga1 · ‎03-09-2021

Hi imran rasheed,

Can you please share the answer for this question