SQL Server Job Agent asynchronous?

• elogen

  SSC Eights!

  Points: 839

  More actions

  September 5, 2011 at 9:03 pm

  #242833

  Hi,

  I wanted to schedule a Job using SQL Server Job Agent to run every minute. This job will then call a single stored procedure EXEC dbo.MyStoredProc. This stored procedure may take a much longer time to finish ie: it can take 7 to 10 min to finish executing.

  I want to know if I schedule the Job to execute every minute, would it have to wait until the previous call of the stored procedure finished before it executes it again? Or does it just call it straight away (asynchronously)?

  Thanks.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  September 5, 2011 at 10:09 pm

  #1377171

  It will wait until the completes and execute at the next interval.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/