SQL Agent Job locking

Question

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.

Answer 1

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:

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.

Answer 2

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.