sql server的计划任务和消息队列

-- sql server也有【计划任务】，方案有很多，比如：
-- 要以1秒的间隔延迟后执行'somewhat job' ,可以使用以下代码:
CREATE PROCEDURE SP_Execute_PlanningTasks 
AS 
    WHILE 1=1
    BEGIN
     WAITFOR 
       DELAY '00:00:01'  -- 延迟1秒再执行下面的EXECUTE 'somewhat job'
       -- TIME  '23:50:00'  -- 每晚23:50:00执行下面的EXECUTE 'somewhat job'
     EXECUTE 'somewhat job'
     -- sp_execute ***
     -- sp_executesql ***
    END
END
-- 运行存储过程SP_Execute_PlanningTasks在每个SQL Server启动后立即执行:
exec sp_procoption N'SP_Execute_PlanningTasks', 'startup', 'on'

WAITFOR 
{
    DELAY 'time_to_pass' 
  | TIME 'time_to_execute' 
  | [ ( receive_statement ) | ( get_conversation_group_statement ) ] 
    [ , TIMEOUT timeout ]
}

WAITFOR (Transact-SQL) | Microsoft Docs

RECEIVE (Transact-SQL) | Microsoft Docshttps://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms186963(v=sql.90)

CREATE QUEUE (Transact-SQL) | Microsoft Docs