Chasing up Pending Approvals

[hong_cheung]

Hello,

We have a workflow in Change Management whereby email approvals are sent to various approvers.   However, sometimes an approver does not reply and causes the change to not progress.

Is it possible for an automated rule or task to resend the initial email notification every day until they respond?

Thanks you in advance,

Hong

[stephmcl303]

Hi,

Were just about to implement something similar....

You can do this by creating a scheduled job to pick up pending approvals within the date criteria you want and if it finds any re-trigger the event that fires off the notification or create an new event and notification specific to the reminder

[stephmcl303]

This link might help

Thanks for your response,

[James Hammond]

Hi,

We are implementing this by using a scheduled job also, code included below;

var gr = new GlideRecord("sysapproval_approver");

gr.addEncodedQuery("state=requested^sys_created_onRELATIVEGE@dayofweek@ago@2");

      gr.query();

while(gr.next()){

    gs.eventQueue("reminder.approval.requested", gr, [gr.approver.email.toString()].toString());

}

This generates an event that triggers the email notification, which is for any approval older than 2 days; and the best thing is that this is run as a daily job; so the reminders will then go out daily until the approval state is changed.

[TSP666]

Hi James,

I implemented this in my instance and it works well except it sends reminders for all outstanding approvals less than 5 days old and not older than 5 days.

Any idea what I have done wrong ?

Regards

Tony

var gr = new GlideRecord("sysapproval_approver");

gr.addEncodedQuery("state=requested^sys_created_onRELATIVEGE@dayofweek@ago@5");

      gr.query();

while(gr.next()){

    gs.eventQueue("reminder.approval.requested", gr, [gr.approver.email.toString()].toString());

}