Use wait delay in SQL Server for waiting or sleep.
WAITFOR DELAY ‘000:00:01’ is used to put the system to sleep before executing the next query.
For 1 minute delay: WAITFOR DELAY ‘000:01:00’
Example: Put 5-second detail in the script to execute your SQL Query:
DECLARE @i INT = 1; WHILE (@i <= 60) BEGIN WAITFOR DELAY '00:00:05' /*Your Script*/ SET @i = @i + 1; END
Example: Use the Wait Delay option in Procedure to wait for 30 seconds before executing the SQL Server Select statement:
ALTER PROCEDURE testwaitfor30 AS SET NOCOUNT ON; waitfor delay '00:00:30' SELECT LastName, FirstName, JobTitle, Department FROM HumanResources.vEmployeeDepartment;