SQL Agent jobs do not run as scheduled after change the time zone to a previous time

• 313693022

  SSC Veteran

  Points: 241

  More actions

  May 21, 2013 at 8:30 am

  #274097

  (1)I create a job and schedule it to run every 20 seconds.

  (2)I change the time zone of the sql server machine and the machine time(2013-05-21 11:00:00) is earlier than current time(2013-05-21 16:00:00).

  (3)This job can run manually, but can not run automatically as scheduled.

  Need your helps.:-)

• Neeraj Dwivedi

  SSCertifiable

  Points: 6768

  More actions

  May 21, 2013 at 1:40 pm

  #1617170

  run

  select * from msdb..sysjobactivity

  check for next_scheduled_run_date.

  You have to reschedule the job if the next_scheduled_run_date is off.

• chawiro

  SSC Rookie

  Points: 41

  More actions

  March 22, 2014 at 9:43 pm

  #1699328

  Hello, just disable-save-re enable - and save the job schedule... it worked for me

  cheers !