How to auto update next run time for scheduled jobs

Hi, I have a laptop with sql 2005 installed sp2.. version 9.0.3054  

I also have plenty of sql agent jobs that run hourly.

My problem is that in the afternoons, i put my laptop in hibernate and take it home, and in the morning when i turn it back on, the sql agent jobs time for next run is always in the past. It doesn't realize that time has passed and need to run in the next hour.
How to get pass this problem.

LVL 13
WizillingAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jagdish DevakuSr DB ArchitectCommented:
Hi,

I think by changing the 'Schedule Type' option to "Start automatically when SQL Server Agents starts"

You can find this option by right click on the SQL Agent Job and Select 'Schedule'

Please let me know if you find any issue....

bye///
0
WizillingAuthor Commented:
Hi, I have already tried that. When I put my laptop into hibernation, None of the services stop... so when i resume my laptop again, none of the services have to start (since they are already started ) and that event wont fire.
0
Jagdish DevakuSr DB ArchitectCommented:
Yeah u r right...

I would like to know, what exactly u require...??
0
WizillingAuthor Commented:
After I resume my laptop from hibernation ,the next run time (in sql server agent jobs) still shows old time..  I would like to how what must I do so that sql can update its next run time according to the schedule which is next two hours.
0
WizillingAuthor Commented:
i created a job that would find all jobs that have past the next run time and start them up again. I have scheduled it to run at differnent schedules so this particular refresh job doesnt itself get missed.
However this is only a work around I am using and a proper solution has been found yet.
Problem is that sql server agent doesnt realise that next run time has passed and not smart enough to re-schedule time itself...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.