Resend approval email if it has not been approved after 24 hours

[bradschamerloh]

I need to re-send an approval email if it has not been approved/rejected after 24 hours.

I have an approval notification that is sent when a record is inserted or updated.   The notification is NOT triggered by an event.   The problem is, I cannot figure out how to re-send the SAME email 24 hours if state=requested on the sysapproval table.  

WORKFLOW:

NOTIFICATION:

[Michael Ritchie]

Workflows aren't the best way to accomplish this and a scheduled job can easily do the trick.   You may want to look at ctomasi's Scriptless Scheduled Jobs solution for an easy way to solve this:

Scriptless Scheduled Jobs

[bradschamerloh]

I was hoping I wouldn't have to re-build the workflow since we're in the middle of a SOX audit that's spitting out an average of 3000 email approvals every day.......

[Michael Ritchie]

Sorry for the confusion, you absolutely don't need to touch the workflow at all.   A scheduled job will evaluate your condition of approvals not approved within X hours and resend the emails.   This is outside of the workflow which should help.   Any type of recurring situation is best handled in scheduled jobs.

[bradschamerloh]

But in this case, the email notification is being sent because a record is being produced, not because it's triggering an event.

I've used this scheduled job in the past, but I'm not triggering an "event" here