asked on

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.

Jagdish Devaku

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

Wizilling

ASKER

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.

Jagdish Devaku

Yeah u r right...

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

Wizilling

ASKER

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.

ASKER CERTIFIED SOLUTION

Wizilling

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial