Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Subscriptions have stopped runnning, need help! Expand / Collapse
Author
Message
Posted Wednesday, March 13, 2013 11:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 10, 2014 1:50 PM
Points: 5, Visits: 54
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,

Post #1430539
Posted Wednesday, March 13, 2013 2:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 10, 2014 1:50 PM
Points: 5, Visits: 54
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,

Post #1430634
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse