SQL Reporting Services Unreliable?

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?

Thanks!
Roxanne25Asked:
Who is Participating?
 
TempDBACommented:
The schedule says you want to run the report every 99 weeks once. Change it to every week. This is the only bug here.
0
 
TempDBACommented:
This is weird and I haven't come across such a situation. I have lots of reports subscribed to huge number of clients.
However, while configuring them in my earlier days, I did the subscription wrongly. Could you check the subscription and the a/c which it runs and give some screen shots which will help us here.
0
 
Roxanne25Author Commented:
Ok, I'm attaching screenshots I took of the subscription.  Please note, this happens on more than one report but I only took screenshots of one of them. Screenshot1 Screenshot2 Screenshot3
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Roxanne25Author Commented:
Oh geeze, what a silly mistake.  I thought that was saying how many weeks do I want it to run for... so I should just put a 1 there?
0
 
TempDBACommented:
yup..
0
 
Roxanne25Author Commented:
LOL, that fixed it.  Thank you for pointing out my dumb mistake. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.