Cacher is the code snippet organizer for pro developers

Declare  @DelayLength char(8)= '00:00:00'  .

WAITFOR DELAY @DelayLength  
SELECT @ReturnInfo = 'A total time of ' + @DelayLength + ',   
    hh:mm:ss, has elapsed! Your time is up.'  
-- This PRINT statement is for testing, not use in production.  
PRINT @ReturnInfo;

BEGIN  
    WAITFOR DELAY '02:00';  
    EXECUTE sp_helpdb;  
END;  
GO 

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