[Webinar] Learn how to a build a cloud-first strategyRegister Now


How to auto update next run time for scheduled jobs

Posted on 2008-11-10
Medium Priority
Last Modified: 2012-05-05
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.

Question by:Wizilling
  • 3
  • 2
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 22928644

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....

LVL 13

Author Comment

ID: 22933206
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.
LVL 14

Expert Comment

by:Jagdish Devaku
ID: 22937340
Yeah u r right...

I would like to know, what exactly u require...??
LVL 13

Author Comment

ID: 22942833
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.
LVL 13

Accepted Solution

Wizilling earned 0 total points
ID: 23000475
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...

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question