|
|
Posted by Roy Harvey on 08/18/06 12:19
On alternative would be a watifor loop. Here is an example using a
five second delay over one minute.
declare @t datetime
set @t = dateadd(second,60,getdate())
WHILE getdate() <= @t
BEGIN
--do something here
select getdate()
waitfor delay '00:00:05'
END
Roy Harvey
Beacon Falls, Ct
On 18 Aug 2006 02:59:45 -0700, "Jim Devenish"
<internet.shopping@foobox.com> wrote:
>Erland Sommarskog's procedure aba_lockinfo provides very valuable
>information when trying to sort out locking and blocking problems.
>
>However is only provides a snapshot in time.
>
>Is it possible to have this run continuously for a period of time? or
>possibly at set intervals, say every minute?
>
>If so, how would one set it up?
Navigation:
[Reply to this message]
|