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,