how to monitor the system clock for changes

[Dica]

i'm working on a windows service that needs to check the system's clock
every minute and see if there are any jobs in my database taht are scheduled
to run at that time:

sSql = "select * from tblJobs where runTime = " + dtTheCurrentSystemTime

are there any classes designed to allow me to monitor changes to the system
clock?

tks

 

[Guest]

Check the following link. You might have to do some indenting though, as
there seems to be a bit of a problem with the source code being displayed.

http://msdn2.microsoft.com/en-us/library/ms172517(vs.80).aspx#Mtps_DropDownFilterText


Adrian.

 

[Guest]

You will want to use a System.Timers.Timer object and handle the Elapsed
event. In the handler, do the checks that you wish. I don't use database
scheduled events, so I cannot address that.