Post reply

JOBs cycle

  • February 5, 2015 at 5:31 am

    #314923

    Hello,

    i found on server jobs which has executing time about 7minutes, but he has schedule every 2minutes.... is it possible that will be in cycle ? or if it will try execute during executing will be canceled this second executing ? thanks for advice

  • February 5, 2015 at 5:50 am

    #1775661

    A job cannot start if it's already executing. If a job is scheduled to start and it's already running, nothing will happen.

    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

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

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