declare @i int
set @i=0
while @i<2
begin
exec('delete from tbMSG where datediff(s,dt_MSG_InsertTime,getdate())>120')
waitfor delay '00:00:30'
set @i=@i+1
end
SQL SERVER 代理作业 间隔到秒
最新推荐文章于 2022-10-13 14:01:49 发布
declare @i int
set @i=0
while @i<2
begin
exec('delete from tbMSG where datediff(s,dt_MSG_InsertTime,getdate())>120')
waitfor delay '00:00:30'
set @i=@i+1
end