-
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?
-
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
-
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
-
Forum Rules
|
|