Job Execution
I've got a scheduled job that runs a package every couple of minutes, and I also have a method in an application that calls a stored proc that can also execute the same scheduled job. My question is what will happen if I call the stored proc to execute the job at the same time that the job is executing on its regular schedule. Is it possible that the an instance of the package will execute in parallel?
September 13th, 2007 1:03am

SQL Agent jobs won't run multiple instancessimultaneously, as long as you are calling the same job.
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2007 5:03am

Similar to above situation, i want to find out that if multiple job (long running jobs, schedule may overlaps between them) are being executed. Can i get timeouts in other queries/procs.
March 24th, 2011 10:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics