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.


Can't find what you are looking for? Go Gooogle...
Google

Leave a Reply


AWSOM Powered