Reporting Services Subscriptions Stop arbitrarily

Hi,
periodically, our Reporting Service seems to fall over with respect to
Subscriptions (visiting subscriptions reveal they are in a state of
pending). We then restart the SQL Agent and the reporting services service
which seems to resolve the problem until it falls over again. Sometimes
this happens several times in a day, other times it may be a week.
Can anyone gives us suggestions as to what might be the cause of this?
thanks
MattYou best bet is to look in the log files and see if there is anything in
there that might lead you to the cause of the problem.
Is the report your rendering a large report? Perhaps it is using up all of
the available machine resources and causing RS to shut down. You may need
to look into using report execution snapshots for the report to lessen the
load on RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:OWUT%23qs8EHA.3700@.tk2msftngp13.phx.gbl...
> Hi,
> periodically, our Reporting Service seems to fall over with respect to
> Subscriptions (visiting subscriptions reveal they are in a state of
> pending). We then restart the SQL Agent and the reporting services
> service
> which seems to resolve the problem until it falls over again. Sometimes
> this happens several times in a day, other times it may be a week.
> Can anyone gives us suggestions as to what might be the cause of this?
> thanks
> Matt
>