SQL Agent Job locking

kkran 831 Reputation points
2021-01-21T22:46:49.247+00:00

Hi Everyone - I have SQL Agent Job scheduled to run every 1 hour. The job runs an SSIS package.
Let's say the job started at 11 AM, Will the job starts at 12 pm as it's been 1 hour, or will it wait for till the 11 Am schedule is completed or successful.

Because sometimes the job runs for more than 1 hour, I was thinking if it causes any deadlock or will the 11 AM job will be suspended.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,734 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
0 comments
Accepted answer
  1. Monalv-MSFT 5,896 Reputation points
    2021-01-22T03:46:22.717+00:00

    Hi @kkran ,

    If we set the job schedule as occurs every day every 1 minute between start time and end time, the job will be started at start time for the first time.

    Starting the job for the second time will wait for the completion of the first job execution.

    Please refer to the following pictures:
    59442-job-schedule.png
    59443-job-viewhistory.png

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,301 Reputation points
    2021-01-22T08:17:35.567+00:00

    If a job is already running, it won't be started. It will not be queued in any way. You would have to wait for the next scheduled execution for this job to run. Below is an example for this.

    I scheduled the job to be executed every 10 seconds. In the job I have a WAITFOR to pause for 12 seconds.

    The first execution was 09:11:20 (hh:mm:ss)
    The second was 09:11:40.

    If the job would be started immediately then the execution on was finished, then the second job would have been started at 19:11:32.

    59497-image.png