ink777
September 18th, 2003, 01:06 AM
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 .
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 .