Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

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!
0
Roxanne25
Asked:
Roxanne25
  • 3
  • 3
1 Solution
 
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
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now