SQL Reporting Services Unreliable?
Posted on 2011-09-21
Hello, I have created some reports in SSRS and deployed them to the SQL reporting manager. I have put them on a recurring subscription that is supposed to execute every week. However, the execution is very unreliable. One week it will work and I'll wake up to the reports in my inbox but constantly I find that the subscription did not even fire off and I have to go in and if I set it to run 1 minute from the current time, it will then execute the subscription.
The whole reason I set this up is so it would be automated and I could forget it. But its constantly just not running. If you look at the last execution time its from the week prior. So, the subscription isn't even trying to run.
Has anyone experienced this before and were you able to resolve it? Or is there another way for me to kick off SSRS reports and have them email delivered?