Post reply

How many SQL agent jobs can we run simultaneously?

  • August 31, 2018 at 9:57 am

    #362284

    Good Morning Experts, 
    How many SQL agent jobs can we run simultaneously?

  • August 31, 2018 at 10:23 am

    #2004155

    The snide response is all of them.  It really depends on the resources available on the server as well as if there are any inter-dependencies between the the jobs.

  • August 31, 2018 at 2:42 pm

    #2004186

    The only limiting factor is SQL Agent will not start a job if it is already running, so even if a job is scheduled to run at 4:00, if someone manually started it or a previous schedule started it and it was still running when 4:00 came around, it won't start another occurrence of it.

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

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