We have an SQL 2005 DB having automated time and attendance for workers in a factory. It is required to print automatically the name of anyone that spent more than 13 hours inside the plant.
The query itself is very simple, but how to automate it?
I thought of creating a vbscript for that and keep it running (as a service preferably) but do not know how.
Please note that I have no experience in vb scripting, and any other suggestions (like some triggers on the database itself) is appreciated.