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.
| Author |
Topic |
|
richardps
Starting Member
33 Posts |
 Posted - 2007-02-08 : 07:11:48
|
| Hi,Has anyone else ever heard of a problem with running an hourly overnight schedule which stops running if the job is running over the turn of midnight?I have an hourly job which runs from 10:30pm to 10:30am and take between 20 and 40 minutes to run. On occasions when it takes 40 minutes and runs at 11:30pm, the scheduler does not execute the job at 00:30 and beyond for that night. No errors, nothing.Your help and suggestions are appreciated.Many thanks,Richard. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-08 : 09:02:35
|
| I have never seem this.You might try setting up two schedules for the job, one starting at 00:30 and running till 10:30, and the next starting at 22:30, and running until 23:30.CODO ERGO SUM |
 |
|
|
|
|
|
SQL Agent Schedule (overnight) problem