Hi Sathwik,
Hope you are safe and good.
You can try this with scheduled jobs.
- Create an event in the registry.
- Create a Scheduled script execution which runs daily at 0800 hrs.
var chg_req=new GlideRecord('change_request');
chg_req.addEncodedQuery('active=true^due_dateRELATIVEGT@dayofweek@ahead@29^due_dateRELATIVELT@dayofweek@ahead@31^NQdue_dateRELATIVEGT@dayofweek@ahead@14^due_dateRELATIVELT@dayofweek@ahead@16');
chg_req.query();
if(chg_req.hasNext())
{
while(chg_req.next())
{
gs.eventQueue('change_request.schedule_reminder',gr,gr.assigned_to.email,'');
}
}
3. Create notification which sends the notification when the event got triggered.
In this example I have used Change Request table. Replace the table name in the glide record also due_date field name.
Please click on helpful if it is.
Thanks & Regards,
Sharath Allam
Kaptius - ServiceNow Premier Partner.
