Send a one off 'follow up' email after 7 days

[daveyk72]

Hi

I would be most grateful for some steer with being able to do the following;

A manager submits a form from the service catalogue which has a workflow that sends out an automated email to the member of staff that is leaving asking them to complete a leaver survey by selecting a link. The next step in the workflow is to assign it to the HR team and create a task for another team.

What I want to do after 7 days is to send a one off automated email to the member of staff leaving regardless if the leaver form has been closed/complete or still work in progress saying if they have completed the questionnaire that was sent 7 days ago, thank you, if you haven't then please do so.

Any ideas would be most appreciated.

Dave

[Chuck Tomasi]

Hi David,

I'll assume you are doing this from a workflow. Take a look at using a timer activity to send that reminder.

Timer Activities - ServiceNow Wiki

[Abhinay Erra]

David,

    What you could do is, create a date/time field on sc_req_item table and hide it from the form layout. Then in the workflow, set this field in the notification activity to current date time. Now you will have to run a scheduled job daily to check for this date/time field and check if it had passed seven days and if yes, trigger a notification by logging an event and clear out this date/time field.

[Gurpreet07]

Hi David,

What i understood is , you are sending the survey on the same day when the form was submitted. I think that the form would be a catalog item. Now you need to send followup email after 7 days from the date of creation of RITM.

You could create a scheduled job for this. GlideRecord the sc_req_item table and apply a filter for catalog item and created 7 days ago. Trigger event for all those records. Configure Email Notification for the event.

[Abhinay Erra]

What if the email notifications are not sent the same day the item was created?