SQL Server Performance Forum – Threads Archive
Server Time
Hello, I am confuse. I got a notification email today regarding my backup job: JOB RUN:’Backup Job’ was run on 11/25/2003 at 10:00:00 PMDURATION:2 hours, 25 minutes, 20 seconds
STATUS: Succeeded
MESSAGES:The job succeeded. The Job was invoked by Schedule 6 (Schedule 1). The last step to run was step 1 (Step 1).
However, the Maintenance Plan History shows: Start date: 11/25/03 10:00:03 PM
End date: 11/25/03 11:13:12 PM
Duration: 4380 hours, 13 minutes, 9 seconds From 10 PM to 11 PM, there is only 1 hour different, why SQL Server Agent shows the duration as 2 hours?
By the way, the SQL Server’s time is correct. My CPU time is correct. The DNS server time is correct. Where else should I check?
May be somethink wrong between mail time and server time.
But, 4380 Hours?
Never see somethink like this. I suggest to consult Microsoft or wait for others oppinions.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
The 4380 hours displayed is a known issue. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;258806&Product=sql2k However, something is still not right will my server time. I have previously created a ticket about my log backup fails on 3:45 daily, only. And the error message stated:"There is a time difference between the client and server.". Well, I changed the log backup time and it worked for 2 days, now I am getting the same error message again……. I wonder what else affected the time…. Help!!!!
Check:
http://support.microsoft.com/default.aspx?scid=kb;en-us;232386
http://support.microsoft.com/default.aspx?kbid=232386
http://support.microsoft.com/default.aspx?scid=kb;en-us;297234 Also: http://www.wilsonmar.com/1clocks.htm Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
]]>