Shedule your SQL Query using SQL Query Analyzer

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.

If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !