Email reminder when time sheet is not submitted

[Julia Allen1]

Hello -

I can't find my thread on this but here is what I am trying to do and getting stuck on step 4 and 5.

I need to have automated emails sent to users at 9:05 AM every Monday who have not submitted their time sheets for review. 

1. Create an Email Notification for the time_sheet table that is sent when an Event is fired (I did this)
2. Add Conditions to make it where State is either Pending/Rejected/Recalled (I did this)
3. In the Who will Receive section, add the User option to the "Users/Groups in fields" field (I did this)
4. Now create a Scheduled Job that runs Daily (I did this)
5. Have the Job create the custom event that we added to the Notification for each time_sheet record that is in one of those states for the current week (this is where I am stuck - I created an event, but I don't know how to tie it to the scheduled job)

Any additional steps to clarify #4 ad #5 would be very helpful. It also needs to keep sending emails to the users until they submit it (so I am thinking that is a second job set to run or a simple script)

[Chris Sutton]

Hi Julia,

Did you have issues with this solution if any of your time sheet users did not access ServiceNow for the week? As in, there is no time sheet record for the user?

Thanks,
Chris