I want to send an approval email reminder that includes the approve/reject links.

[Lisa_Wiegmann]

The email should be sent one day after the initial approval email and then again at day 2 and day 3, if the approver has not approved.  I have done the following:

1. I created an Event Registry against the sysapproval_approver table.

2. I have created a notification on the sysapproval_approver table that fires on my event name

3. In the workflow I have a Timer, an If action that considers the current Stage, and a Create Event.

When I create a request and review it's workflow, I see that my timer, if action, and create event all complete, but no reminder email is sent.  I was able to get the email to send when my Event Registry and notification records were against the sc_req_item table.  The problem with that, is that I couldn't find a way to send it to the approver and include the approve/reject links.

I'd appreciate any ideas.

[Rajababu]

Hi ,

You can do many ways .

1- By workflow which attache to purticular sc_req_item , Under workflow you need attach timer and repeat it or uses rollback option which will check ,approver approved or not ,Till the time it will check .

2- You can create business rule where you can compare associated sys id sc_req_item , have approver  and status is pending and by gs.date time or gs.daysago or many more for date and time use, you can check .

3- Now when Email you need to send including approv/reject email - There is mail script exsiting which you need to call into email notification by using format

${mailto:"mail script name"}

[Rajababu]

Email script you can find by below - 

https://instance.service-now.com/sys_script_email_list.do?sysparm_userpref_module=a52de313ef01110028...

Sorry email script -

 ${mail_script: "your script ")

[Rajababu]

Its something like below 

${mailto:mailto.approval}

${mailto:mailto.rejection}

[Rajababu]

By mail script= 

 ${mail_script:Approval-Links}.