I don’t know if someone else want to know about this but hey, sharing is caring right.

Declare @dateTimeToWait as DATETIME
Set @dateTimeToWait = '2020-11-11 15:02:43.000  '

While (1=1)
BEGIN
 IF getdate() > @dateTimeToWait Break
 -- Sleep for 30 seconds
 WAITFOR DELAY '00:00:30'
END
-- ADD YOUR SQL HERE
Print 'your SQL query goes here'

Till then….adios.