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?