October 2, 2003 at 5:04 am
Hi Guys,
I have a job that runs every 2 hours through the working day.
However, although this runs ok for the first day, after that (on the second day) the Next Run Date is not updated hence the job ceases to run. The job will have to be totally re-created to work again?????
Any ideas!
(As a note, this server is new to me and I have noticed the service packs are not up to date...could this be the problem)
Thanks in advance
Graeme
October 2, 2003 at 5:47 am
The service packs definately should be updated. I've seen before on tran log backups that if the start and end times match the job loses its mind after a day, you might try changing the seconds or minutes for the end time to be different from the starting time.
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
October 2, 2003 at 7:56 am
Double check to make sure the job schedule is set for RECURRING. (Use Enterprise Manager, drill down to Management, expand that, expand SQL Server Agent, click on Jobs. Right click on the job and select properties, go to the Schedule Tab).
-SQLBill
October 2, 2003 at 8:31 am
What type of job it is? Do you create it by using maintenance plan wizard? Please post your SQL Server version and service pack version?
October 3, 2003 at 8:09 am
If you have the schedule set to daily...change it to weekly and then check off the individual days you wish it to run on. This is a known bug in SQL
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply