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.

  • Equation keeps returning int in SQL Server
  • How to push the data from database to application?
  • Issues with T-SQL TRY CATCH?
  • Most concise way to write this query to add hour to a date
  • How do I find week number of a date according to DATEFIRST
  • How do you test for the existence of a user in SQL Server?
  • 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_date and next_run_time for your jobs.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.