Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 job start times

Author  Topic 

oompa
Starting Member

5 Posts

Posted - 2006-04-03 : 18:36:31
What would cause a series of jobs to start at an odd time. Log backups are scheduled to run hourly @ XX:40 and XX:45. However, on 4/2, the jobs kicked off at 2:59. I checked all the jobs and nothing is scheduled to start at 2:59. TIA.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-03 : 18:49:04
Only thing I can think of is that the database server's time changed. I'm not sure if that event would be recorded in Event Viewer though.

Tara Kizer
aka tduggan
Go to Top of Page

nosepicker
Constraint Violating Yak Guru

366 Posts

Posted - 2006-04-03 : 23:49:47
Probably something to do with the time changing to daylight savings time (2:00 AM skipped to 3:00 AM on 4/2).
Go to Top of Page
   

- Advertisement -