Create multiple batch statements with a delay in between each batch execution / T-SQL

gistfile1.sql

/*
Creates multiple batch statements to run a sql statement with a delay in between each batch execution.
*/

DECLARE
@ReportTimeStamp DATETIME,
@ExitConditionTimeStamp DATETIME,
@Sql NVARCHAR(MAX),
@ParamsDefinition NVARCHAR(MAX),
@IntervalInSeconds INT,
@DelayInSeconds INT

SET @ReportTimeStamp = '20110701'
SET @ExitConditionTimeStamp = '20110731'
SET @IntervalInSeconds = 24 * 60 * 60

SET @Sql = 'EXEC YourDatabase.dbo.YourProcedure @ReportDate'
SET @ParamsDefinition = '@ReportDate DATETIME'
SET @DelayInSeconds = 30

WHILE @ReportTimeStamp <= @ExitConditionTimeStamp
BEGIN
PRINT 'BEGIN
WAITFOR DELAY ''' + CONVERT(NVARCHAR(8),DATEADD(S,@DelayInSeconds, '19000101'),108) + '''
EXEC sp_executesql N''' + @Sql + ''', N''' + @ParamsDefinition + ''', @ReportDate = ''' + CONVERT(NVARCHAR(8),@ReportTimeStamp,112) + '''
PRINT ''Query executed:''+CAST(GETDATE() AS CHAR)
END;
GO'
SET @ReportTimeStamp = DATEADD(S,@IntervalInSeconds,@ReportTimeStamp)
END