SQL Server Schedule Reset
We recently had an issue where the date on a server was wound forward a few months and wasn’t noticed. We had a number of scheduled jobs run and now they’re waiting until November until they run again.
I can’t for the life of me find anywhere in SQL Server to change the Next Schedule Run Time.
Anyone have any idea or do I have to recreate each schedule again from scratch?
One Solution collect form web for “SQL Server Schedule Reset”
You can fix this by editing the start date of each job. (open your job -> schedules -> edit schedule -> duration -> start date)
You could although have a look at the table
msdb..sysjobschedules to check all schedules, it contains the columns
next_run_time for your jobs.