Approval Reminder

[aniellacerna]

1. Create a notification that will remind the approver of an unapproved RITM (Note that you can reuse existing RITMs that satisfies the condition no need to create new catalog item or request a new RITM)
2. Create a scheduled job that will trigger the notification created above daily but will not run if the current date is out of schedule (8-5 weekdays)

[Vishal Birajdar]

Hi @aniellacerna 

Can you try below steps : 

Step 1 : Create Event Registry

Name - approval.reminder

Step 2 : Create Notification 

When to Send : Event is fired

Event Name - approval.reminder

Who will Receive : Approver

What it will contain : Your mail body

Step 3 : Write scheduled job

/* Get Day of week */
var date = new GlideDateTime();
var day = date.getDayOfWeek();

/* if not saturday & sunday then run the script */
if (day != 6 || day != 7) {

    /* Get Schedule */
    var shcd = new GlideSchedule('08fcd0830a0a0b2600079f56b1adb9ae'); //sys_id of schedule
    /*Check if date is not in schedule*/
    if (!shcd.isInSchedule(date)) {
        /* Glide record on 'sysapproval_approver' table */
        var gr = new GlideRecord("sysapproval_approver");
        gr.addQuery("state", "requested");
        gr.query();
        while (gr.next()) {
            /*Send the reminder */
            gs.eventQueue('approval.reminder', gr);
        }
    }else {
		gs.log('Date is in schedule');
	}

}

Hope this helps...!!!

[aniellacerna]

what i have notice is that I only want RITM to be able to have notification

[guigilmoura]

I want this to work for the approver added in the SCTASK, not the RITM or the CHG. I'm not being able to make it work. I successfully tested finding the task, and triggering the event which triggers the notification. Im just not able to make the approver in the approval tab of the SCTASK as the recipient

[Vishal Birajdar]

Hi @guigilmoura 

Can you please let us know your exact requirement...??