I have created a database trigger to manage notifications for timesheet managers when timesheets are submitted and recalled, also this trigger sends email to the resource when timesheets have been approved or rejected.
This trigger uses msdb.dbo.sp_send_dbmail and requires that you set up a profile called "Default Email" and have a valid configuration. I did not put the @profile_name as a variable, but is easy enough to do for code portability.
Since it uses database mail, it may not be appropriate for very large or busy timesheet sites, as the sp does use resources on the SQL server.
This trigger needs to be installed in the dbo.MSP_Timesheet table.
I hope this helps someone who spent as much time as I did looking for a solution.
Please note that I am NOT a coder and this is one of my first attempts at writing a trigger in SQL.
Feel free to mod it, improve it or distribute it as you see fit.
Thanks,
Scott Brawner
Link to code
