Scheduled Script Issue

[Johny1]

Hi,

I have a requirement to send 3 approval reminders each a week apart and the request should auto cancel after 3 reminders.

Here I have configured using scheduled job.

How can I send the remaining 2 reminders using the same scheduled job script.

var scApp = new GlideRecord('sysapproval_approver');
scApp.addEncodedQuery('state=requested^sysapproval.sys_class_name=sc_req_item^sys_created_onRELATIVELE@dayofweek@ago@7');
scApp.query();
while(scApp.next()){
	
	gs.eventQueue('sc_reminder1',scApp,scApp.approver);
	
}

[Johny1]

Yes Air.

[AirSquire]

Ok, try the below script

var scApp = new GlideRecord('sysapproval_approver');
scApp.addEncodedQuery('state=requested^sysapproval.sys_class_name=sc_req_item');
scApp.query();
while (scApp.next()){
	var created = new GlideDateTime(scApp.sys_created_on);
	var now = new GlideDateTime();
	
	if (created <= now.addDays(-7)){
		gs.log('Created on 1: '+scApp.sys_created_on+' Days Ago 1: '+gs.daysAgo(7));
		gs.eventQueue('sc_reminder1',scApp,scApp.approver);
	}
	
	else if (created <= now.addDays(-14)){
		gs.log('Created on 2: '+scApp.sys_created_on+' Days Ago 2: '+gs.daysAgo(14));
		gs.eventQueue('sc_reminder2',scApp,scApp.approver);
	}
	
	else if (created <= now.addDays(-21)){
		gs.log('Created on 3: '+scApp.sys_created_on+' Days Ago 3: '+gs.daysAgo(21));
		gs.eventQueue('sc_reminder3',scApp,scApp.approver);
	}
}

[AirSquire]

Hi Johny,

Did that work?

Regards
Air

[Johny1]

No Air.

Only Reminder1 is working 😞

[Johny1]

I tried each condition with different scheduled jobs. There it is working fine.