Results 1 to 3 of 3

Thread: Execute Query After Every 10 mins

  1. #1
    Join Date
    Sep 2002
    Posts
    218

    Execute Query After Every 10 mins

    SELECT CONVERT(varchar, DATEADD(ss, DATEDIFF(ss,(Select Min(Starttime) From CI_tbDevLoadStats)
    ,(Select Max(Endtime ) From CI_tbDevLoadStats)),0),108)

    I have this query how can I execute it after every 10 minutes from query analyser?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Write a loop with

    WHILE condition
    begin
    SELECT CONVERT(varchar, DATEADD(ss, DATEDIFF(ss,(Select Min(Starttime) From CI_tbDevLoadStats)
    ,(Select Max(Endtime ) From CI_tbDevLoadStats)),0),108)


    WAITFOR DELAY 00:10:00
    end

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    Why don't run it as scheduled job?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •