sql server procedure to run at preset time and day
Posted on 2005-03-28
I am interested to find out if there is a way to run a procedure within sql server or other on Fridays at 12:00pm without my interface.
I have a time keeping system that users enter their time weekly into. What I need is a way for the system to automatically run a query to see who didn't enter their time or +/- a preset value(servers always on). I have the query. It would then need to send an preset body email notifying them to enter their time by the end of the day. This would have to be a loop since it could be from 0 to many users which I have in vb(msaccess) code.
I could do this manually from within Access by running vb code to email the users, but I want a more automated way of doing it without me or anyone else having to spawn the check.
Anyone have any ideas...if there is a way to do it in sql server, msaccess, vb or other I would be interested.
I think this question is generic enough that you won't need any specifics(table/field names). I just need a basic model or idea and, hopefully, I could take it from there and fill in the rest.