I have a VB app that uses SQL Server 7.
The app creates jobs in the Jobs table, the structure is irrelavant for this Q.
30 days after the job is created it's status is set to cancelled.

In the Sub Main of my app I can run a procedure which checks all jobs and if any are found that are over 30 days old then the app sets the Cancelled field to TRUE.
The problem occurs when another app also uses the data in the jobs table. If someone doesn't run the main app then jobs which are greater than 30 days will still be shown as being effective.
Does SQL Server have an event where I can set it to run at Midnight everyday. This event would run a stored procedure which would automatically cancel jobs...Anyone know if this is possible???