guveniscan
asked on
How to trigger a periodic control in a database
Hi,
I have a table containing a field lastModificationTime, I want to do periodic controls over the records, say every 5 mins, in this field and if there has been more than 5 mins I want to update that record. I am using MS SQL Server 2008, how can I accomplish this?
I have a table containing a field lastModificationTime, I want to do periodic controls over the records, say every 5 mins, in this field and if there has been more than 5 mins I want to update that record. I am using MS SQL Server 2008, how can I accomplish this?
you can use SQL Jobs.
more about SQL jobs.... have a look at good article, you can use it for your task with tweak.
http://msdn.microsoft.com/en-us/library/ms189258.aspx
http://msdn.microsoft.com/en-us/library/ms135739.aspx
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx
http://msdn.microsoft.com/en-us/library/ms189258.aspx
http://msdn.microsoft.com/en-us/library/ms135739.aspx
http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx
ASKER
I'm sorry but the links you provided are not very clear to me. I want to update all the records in a table every 5 mins. Can you give a more clear explanation?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.