Posted by Dan Guzman on 12/20/05 06:29
I've seen WAITFOR DELAY used in order to execute a proc at very frequent
intervals (e.g. every minute or less). However, a scheduled job is a better
fit for less frequent executions since that gives you job history and
failure notification.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"brogdonm" <Brogdons@gmail.com> wrote in message
news:1135036649.313243.99790@f14g2000cwb.googlegroups.com...
> Is it a bad idea to do something like
>
> WHILE (1<>0)
> BEGIN
> WAITFOR TIME '04:00'
> .
> .
> .
> END
>
> It seems like that would work as long as WAITFOR actually yields the
> processor.
>
> Mike,
> <><
>
[Back to original message]
|