Stored procedures??

[ink777]

I have a web based application which uses a database table containing a list of tasks .
If a particular task is not done in a predetermined timeframe, I need to notify the managers. This notification should be done regardless of anybody being logged in .
Maybe, I could check the task entries in the table every 10 minutes and notify .
What is the best way to do this?
Triggers can only be used during updates, inserts or deletes.
I think Stored procedures is the other option . Is there any other way this can be done?( for eg. User defined functions??)
My main issue is carrying out this task at regular intervals .

[antares686]

What you will want to use is a Job, under SQL Server Agent you can create jobs based on SQL, ActiveScript or Executables to run based on a timeframe then just set to run every 10 minutes or however you want.