Posted by Greg D. Moore \(Strider\) on 12/20/05 05:52

"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.

There's far better ways of doing this, as Dan suggested, SQL Server agent is
the way to do it.


>
> Mike,
> <><
>

[Back to original message]