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 !

Related Post:
  • Select count(distinct fieldA) in access
  • MS-SQL - List trigger in your db.
  • SQL Injection Attack using T-SQL and HEXADECIMAL
  • MSSQL - ORDER BY with a specific words
  • SQL - Not In vs Not Exists



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

    Leave a Reply


    AWSOM Powered