There are times when you want to delay a script such as sending yourself a reminders or to run a job/stored procedure/etc.
Wait by Time
BEGIN
WAITFOR TIME ’01:10′;
PRINT ‘This message will print at 1:10 am’;
END;
Wait by Delay
BEGIN
WAITFOR DELAY ’01:00′;
PRINT ‘This message will print in one hour’;
END;
afterowl 