Time delay on a query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Time delay on a query

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-05 : 08:10:35

andrew writes "Hello,

I have a query that once I have done the @query I need it to rerun every 15mins on its own in the back ground displaying either the results or "no rows selected".

Is there a way this can happen?

thanks"

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2005-01-05 : 08:16:58

How are you running this query? In application code, or QA or .... ?

You could set up a SQL agent job scheduled to execute the query every 15 minutes, and write the results to a text file.

You could try using WAITFOR DELAY:


set nocount on
declare @Do int
set @do = 0

while @do <= 9
	BEGIN
	set @do = @do + 1
	WAITFOR DELAY '00:15:00'
	select 'Hello'
END

But that doesn't seem to display until it reachers the end of the loop.

Or, your code could invoke the SQL, display the reult, and have a time based loop...

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources