Post reply

Is job a PARALLEL THREAD or SEQUENTIAL?

  • September 10, 2015 at 5:42 am

    #307602

    Hi All,

    I have a question in SQL Jobs. Is job a PARALLEL THREAD or SEQUENTIAL?

    I mean, I have a job and it should trigger for every 1 minute. Let us suppose it will take 10 minutes of time to perform the actions that we specified inside it. In the mean, whether the Job is triggered or not for the second minute?

    Thanks in advance.

  • September 10, 2015 at 6:27 am

    #1825640

    If the job is already running, it won't start a second time.

    In your example, after the job has completed, on the next 1 minute interval it'll start again.

    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

  • September 10, 2015 at 10:58 am

    #1825759

    You mean to ask if they're re-entrant. They're not.

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

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