Hi Shilpi,
PFB the steps:
1) Register and event through Event Registry.
2) Configure Notification as below
3) Create a Scheduled job from System definition->Scheduled Job.
4) Select Automatically run a script of your choosing.
5) Create a job with run field as daily and select a particular time on which this job will trigger.(I have selected on demand for test purpose).
6) Write below script under Run this script.
var gr = new GlideRecord('x_197397_test_appl_test123');// give your table name
gr.query();
while (gr.next())
{
//gs.info("expiry date :"+exp);
var dt = new GlideDateTime().getDate();
var dt1 = new GlideDateTime(exp).getDate();
var diff = GlideDateTime.subtract(dt,dt1);
var a = diff.getDisplayValue();
var arr=a.split(" ");
var day =arr[0];
if(day == 15)
{
gs.eventQueue('x_197397_test_appl.Reminder for expiry',gr,gr.caller,gs.getUserID());// give your event name in first parameter and pass the parameter 3rd and 4th as per your requirement
}
else if(day == 10)
{
gs.eventQueue('x_197397_test_appl.Reminder for expiry',gr,gr.caller,gs.getUserID());
}
else if(day == 5)
{
gs.eventQueue('x_197397_test_appl.Reminder for expiry',gr,gr.caller,gs.getUserID());
}
}
Hope this helps.
Regards,
Monika
Yes i am working on OOTB incident table.
Please find attachment with their names specified
Event Regstry
Schedule Job
Notification Images
