>BEGIN > WAITFOR TIME '22:20' > EXECUTE update_all_stats >END>
>CREATE PROCEDURE time_delay @@DELAYLENGTH char(9) >AS >DECLARE @@RETURNINFO varchar(255) >BEGIN > WAITFOR DELAY @@DELAYLENGTH > SELECT @@RETURNINFO = 'A total time of ' + > SUBSTRING(@@DELAYLENGTH, 1, 3) + > ' hours, ' + > SUBSTRING(@@DELAYLENGTH, 5, 2) + > ' minutes, and ' + > SUBSTRING(@@DELAYLENGTH, 8, 2) + > ' seconds, ' + > 'has elapsed! Your time is up.' > PRINT @@RETURNINFO >END >GO >-- This next statement executes the time_delay procedure. >EXEC time_delay '000:00:10' >GO >Ok, thanks for all that, but, I meant to be able to pause it manually when desired.