Continuously checking database from a Windows service

Posted by JonF on Stack Overflow See other posts from Stack Overflow or by JonF
Published on 2010-03-07T18:31:44Z Indexed on 2010/03/08 4:36 UTC
Read the original article Hit count: 275

Filed under:
|

I am making a Windows service which needs to continuously check for database entries that can be added at any time to tell it to execute some code. It is looking to see if it's status is set to pending, and it's execute time entry is > than the current time. Is the only way to do this to just run select statements over and over? It might need to execute the code every minute which means I need to run the select statement every minute looking for entries in the database. I'm trying to avoid unneccesary cpu time because I'm probably going to end up paying for cpu cycles on the hosting provider

© Stack Overflow or respective owner

Related posts about sql

Related posts about windows-services