TSQL - WAITFOR- Implement a timed delay

-- Wait until 11pm before proceeding
WAITFOR TIME '23:00'
GO

-- Wait for 30 minutes before proceeding
WAITFOR DELAY '00:30:00'
G