Very Computer

by **robert rei** » Wed, 29 Jan 2003 01:32:36

I need to perpetually call a stored proc between a time
range, from 9.00 am to 10.00pm. We are using a real time
system and need to run an algorhythm every 5 seconds.
Obviously MS Agent only has a time span of 1 minute so we
are wondering about using the Delay function. What I want
to know is this a good idea, what are the pitfulls of
using it, the best way of using it etc. Any help would be
gratefully recieved.

by **Keith Kratochvi** » Wed, 29 Jan 2003 01:38:30

I use WAITFOR DELAY within jobs that need to run more often than one minute.
It works great.

SELECT getdate()
go
WAITFOR DELAY '0:00:05'
go
SELECT getdate()
go

--
Keith, SQL Server MVP

Quote:> I need to perpetually call a stored proc between a time
> range, from 9.00 am to 10.00pm. We are using a real time
> system and need to run an algorhythm every 5 seconds.
> Obviously MS Agent only has a time span of 1 minute so we
> are wondering about using the Delay function. What I want
> to know is this a good idea, what are the pitfulls of
> using it, the best way of using it etc. Any help would be
> gratefully recieved.

Very Computer

Using Delay()

Using Delay()

Using Delay()