As we already know we have OOTB fetaure in Project Server to send alerts and remineders for delayed Tasks. But we don't have such feature for Project Server timesheets.
Here Timehseet Mamager have to communicate manually for submission of delayed timesheets from their defaulter resources.
Now to automate this process, I have created this attached stored procedure which fetches all the timesheet defaulters
from reporting database. Using SQL Cursor sends Alerts and Reminder mails to them individually using Database Server.
This Idea I got while resloving this query where cleint requires that it only receives notification for filling timesheet to its users and no notification emails for task updates/ tasks approvals etc.
This stored procedure requires to configure your Database Server to send mail. Configuration details are also mentioned there in