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

  • (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.:-)

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

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

    cheers !

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply