What should i research in order to accomplish this task?

I am using MS-SQL & VB.Net

I have a SQL table that stores `startdate` and `enddate`. I want to run a query on that table every 10 minutes in order to check if the `enddate` is greater than today and if it is I would like to add a 1 to another column if it is not I would like to add a 0. 

How can I achieve this?