Need to send reminder email with number of days left for auto closure

[rambo1]

Hi,

I am using below schedule job to close resolved cases in 3 business days, Now I want to send email to users with number of days left for closure of resolved case incase there is not response. for example, if case is resolved on friday, schedule job should run every day except on weekends and send email to user with number of days left for closure. i.e on monday 2 days left, tuesday 1 day left. Below is the schedule job used for closing :

var encQue = 'active=true^state=6^resolved_atISNOTEMPTY';
var gr = new GlideRecord('sn_customerservice_case');
gr.addEncodedQuery(encQue);
gr.query();
while(gr.next())
{
var nowGdt = new GlideDateTime(gr.resolved_at);
var myScheduleID = '090eecae0a0a0b260077e1dfa71da828'; //8-5 weekdays excluding holidays sys_id
var dueDays = 3;
var dueWorkingHours = 8;
var dueSeconds = dueDays*dueWorkingHours*60*60;
var leadTime = new GlideDuration(dueSeconds*1000);
var dueDateGdt;
var schedRec = new GlideRecord('cmn_schedule');
if (schedRec.get('name', myScheduleID))
{
var sched = new GlideSchedule(myScheduleID);
dueDateGdt = sched.add(nowGdt, leadTime, '');
}
if (dueDateGdt < gs.nowDateTime())
{
gr.setValue('state',3);
gr.update(); // please uncomment during testing.
//gs.print("Case NUmber from schedule job"+gr.number);

}
}

I would like send reminder every day after case gets resolved and with number of days left for the case to be autoclosed.

How do I get that number of days left for closure? subtraction of present resolved date and closed date doesnt work as I should show only business day. any suggestions?

[Kieran Anson]

Where is your issue? In the notification body? Can you be more specific please.

[rambo1]

In getting number of days left for auto closure

[Kieran Anson]

Ah yeah,

you'll need to take the value of closnum and subtract days var to get the value you want