sql server notification services: realtime clock fall behind quantum clock -- sql server notification services

realtime clock fall behind quantum clock

Balaji Ramachandran
5/9/2005 3:02:02 AM

sql server notification services:

Hi ,

I notice in my production environment that the realtime clock fall behind
the quantum clock nearly 5 hours.

select StartTime from nsquantum1(nolock)
where quantumid = (select max(quantumid) from nsquantum1(nolock))

select getdate()

Results....

StartTime
------------------------------------------------------
2005-05-09 09:59:01.483

2005-05-09 04:59:23.450

What would be the impact ?

Do I need to sync them manually?

How do I do that?

Thanks.

Regards,
R.Balaji

Re: realtime clock fall behind quantum clock

Shyam Pather [MSFT]
5/9/2005 12:53:56 PM

Balaji,
The clock isn't behind - it's just showing you time in UTC, which is offset
from local time, depending on where in the world you are. My guess is you
are 5 hours ahead of UTC...
-shyam

--
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/
---------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
---------------------------------------------
[quoted text, click to view]