SQL Agent question, will a job start if it's already running?

• jasona.work

  SSC Guru

  Points: 50220

  More actions

  May 21, 2014 at 11:34 am

  #291647

  I'm thinking the answer to my question is no, based on what I saw in the history of a job on one of my servers, but I'd like to check with others.

  I tried Googling for the answer, but either I wasn't using the best terms, or it's never come up...

  Basically, if I've got an Agent job that does something, doesn't matter a whole lot what, and it runs long enough that it should start again, what happens?

  Does it start another "instance" of itself?

  Or, does it skip until the next scheduled time?

  What I saw:

  A job on one of my servers runs every 30 minutes. At one point, it ran for 36 minutes, and skipped the run that should've occurred at the next half-hour.

  So I'm inclined to think that the 2nd answer, it skips until the next scheduled time, is correct.

  Thanks,

  Jason

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 21, 2014 at 11:50 am

  #1715451

  An already running job cannot be started again until the first run completes.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question