SQL

wait delay in sql server

--The format is hh:mi:ss.mmm.
WAITFOR DELAY '00:00:02';

wait for in sql server example

EXECUTE sp_add_job @job_name = 'TestJob';  
BEGIN  
    WAITFOR TIME '22:20';  
    EXECUTE sp_update_job @job_name = 'TestJob',  
        @new_name = 'UpdatedJob';  
END;  
GO