Email Subscription Question
-
Is there a way to keep Reporting Services from sending an email from a timed email subscription when there is no data in the report?
Thanks,
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
I'd like to know if this is possible too. I have a suspiscion someone will say you need a data driven subscription, which is only available in SQL Ent Ed.
-
Yeah, I looked at that, I do have Enterprise Edition, but don't want the complexity that comes with it as I am a consultant and won't be around to maintain the solution.
I did do a work around. I created the subscription and then disabled the schedule on the SQL Server Job it created. I then created another job that queries the table and runs the Report Server Email job if there are any records.
I probably should look more into using a data-driven subscription.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
🙂
http://www.sqlservercentral.com/columnists/jselburg/2824.asp
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. Selburg -
I glad you removed the complexity.
-
The explanation is more complex than the implementation as all I did was create a job that starts a job when the data has changed. Also the folks I am working for understand SQL Server jobs already and are not all that willing to look stuff up for themselves. Since they are unfamiliar with Data-Driven Subscriptions, which do not do what I need anyway, and I am will not be available to them shortly, it makes sense to use something they can understand a little easier.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply