how to monitor the system clock for changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dica - 19 Jul 2007 19:23 GMT

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

Reply to this Message

Adrian Voicu - 19 Jul 2007 20:28 GMT

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.

Signature

[Please mark my answer if it was helpful to you]

> 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
[quoted text clipped - 6 lines]
>
> tks

Reply to this Message

ModelBuilder - 20 Jul 2007 03:20 GMT

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.

> 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
[quoted text clipped - 6 lines]
>
> tks

Reply to this Message

how to monitor the system clock for changes

Free Magazines