Home Forums SQL Server 2005 SQL Server 2005 General Discussion Does sql job skips the secdulted time , if job takes more time to finsh than the scheduled time. RE: Does sql job skips the secdulted time , if job takes more time to finsh than the scheduled time.

  • If you have a job scheduled for 2pm, 4pm and 6pm, the job starts at 2pm is still running at 4pm and finishes at 4:15pm, the job wills start again at 6pm.

    If the job is still running at the time it is scheduled to start again, SQL Agent won't start it. It also won't 'delay' that schedule. Instead the job will start at its next scheduled time.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass