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

[=?Utf-8?B?QWRyaWFuIFZvaWN1?=]

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/lib...DownFilterText
Adrian.
--
[Please mark my answer if it was helpful to you]


"Dica" wrote:

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

[=?Utf-8?B?TW9kZWxCdWlsZGVy?=]

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.

"Dica" wrote:

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