Subscriptions have stopped runnning, need help!

  • I could use some suggestions on how to resolve problems with SSRS. We currently have several subscriptions that run thoughout the day that have stopped running, I can run the reports manually and they produce fine, but none of the subscriptions are getting emailed to the users.

    1) Should I restart SSRS Service?

    2) should I restart SQL Server Service?

    Note: we have replication running on this server as it gets it's data from our production transaction system, we use this server for reporting.

    I could use any help or suggestions as I am the only one on our team that has any SQL knowledge (And that mine is limited.)

    Thanks in advance,

  • Ok, I figured this one out. I just needed to start and stop the SSRS service and all was working fine. After looking at the error logs (ReportServerService_Date.log) I was able to see what my error was because the error message was listed.

    Hope this can possibly help someone else,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply