I am working on a asp.net web site in that i have a need to run a background process.
but i donot want to make the background process in asp.net as
after i start this process, I will not have any control on the process which i want to have.
So I read that i can call an SP or may be a Function at regular interval of time in sql server.
this is what i need to do.
I have a table in my sql server and i this table has a column of DataTime.
Now I want to run a code which will check take this DateTime column for each record in the table and Add 20 min into this.
and then will check the result.
if it is more than the current time then that particular record will be deleted from the table.
I need this code to run at a regular interval of time.
how can i do this?