MSSQL - Execute stored procedure every second

Watch this example on YouTube


while (1=1)
https://www.blogger.com/blogger.g?blogID=3931774540462211731#editor/target=post;postID=5769642921812394595;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=0;src=link begin
    begin try
        exec spTest
        waitfor delay '00:00:01'
    end try
    begin catch
        select ' error ' + cast(getdate() as varchar)
    end catch
end