Share via


how to add delay between steps within sql agent job

Question

Friday, April 20, 2018 4:35 PM

I want to pause for 10mins between two steps in a SQL server agent job withing management studio.Pls let me know how to accomplish.

All replies (2)

Friday, April 20, 2018 4:36 PM âś…Answered

put a tsql step in that does this

WAITFOR DELAY '00:10:00'


Monday, October 15, 2018 2:09 PM

Hello,

If I am in SQL Server Agent and create a Job with 4 steps and include the WAITFOR DELAY '00:10:00' in step 3 out of 4, will this cause any locks or issues I need to be aware of? Will it interfere with other jobs since this job will take an extra 10 minutes to run?