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: 291
sql
|windows-services
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