/*
使用while,调度过程
*/
DECLARE @A1 INT,@A2 INT,@DT DATE,@DT2 DATE
SET @DT2=‘2020-04-01’
SET @A1=1
SET @DT=CONVERT(DATE,@DT2)
SET @A2=DATEDIFF(DAY,@DT,CONVERT(DATE,GETDATE()))
WHILE @A1<=@A2
BEGIN
EXEC PROC_XXX @DT2
SET @A1=@A1+1
SET @DT2=DATEADD(DAY,1,@DT2)
END