SQL Server Performance

Job schedule

Discussion in 'SQL Server 2005 General Developer Questions' started by sfunds, Feb 18, 2010.

  1. sfunds New Member

    I have three scheduled at 7 pm at nightMy daughter changed the system time setting to 2011 which i noticed later and rectified.However the jobs now show last run on 10 feb 2011 next run 11 feb 2011which table i have to rectify to enable the jobs running ThanksSridar
  2. preethi Member

    I haven't seen this problem before, but this is what comes into my mind.
    If you execute the job manually, it will automatically set the next scheduled date to tomorrow.
    You can also open the job and change the schedule. It will automatically change the scheduled date for next execution.
    In worst case you can add a different schedule to the job.
  3. satya Moderator

    Did you tried to restart SQLAgent after changing the date to current?

Share This Page