Automatic Notification per 2 business days

[dianemiro]

Hi Guys,

Can anyone help me on how to create an automatic notification to requested for of a Request Item if the tickets are still Waiting for Approval and Created more than 2 days. Many thanks for your help.

[snehabinani26]

Hi Diane,

Please mark correct/helpful based on impact

If your question is answered , please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

[Venkateswarlu K]

Every thing looking good but

in the above Send when   fields replace with the event is   fired

[dianemiro · Accepted solution]

Hi All,

Thank you ALL so much for your help. All replies are helpful. For record purposes, I will summarize and combine all suggested solution:

Step 1. I created a Template for the Notification.

Step 2. I created an Event.

Step 3. From this Template I created a Notification thanks to Kuruva Venkateswarlu and Amlan Pal.

Step 4. I created a Scheduled job (script from @Sneha Binani)

var gr = new GlideRecord("sc_req_item");

gr.addEncodedQuery("stage=waiting_for_approval^sys_created_onRELATIVELT@dayofweek@ahead@2^cat_item=da4e262f3784620065f498a543990ed4");

gr.query();

while(gr.next()){

gs.eventQueue("sap_user.requesters.reminders",gr,"","");

}

For Wednesday:

For Friday:

I was able to complete what I want. Again thank you all!!!

[Venkateswarlu K]

Yes Exactly that was looking   awesome Diane Miro