November 17, 2009 at 5:22 pm
Hi guys,
Here are my questions about SSRS 2008?
1-Is it possbile to add Notification email to the reports that has been created in SSRS. Example:We have set up a report which will be sent to the client through email,Now we want to set a notification email,so if something happened(Successfully run or Any failure) the DBA would be notified.
2-We have setup a report .We deliver this report as a file attachment.Is it possible to re-name the name of this file?Because as default the "reportname+ExecutionDateTime" will be the name of the report.
3-Is it possible to enable/Disable a created report.(The only thing that I found was removing all the subscriptions related to the report).
Thanks
November 19, 2009 at 9:56 am
I think you will find this article interesting.
http://www.sqlmag.com/Articles/ArticleID/102645/102645.html?Ad=1
Thanks,
Neal
May 19, 2013 at 8:16 am
1-Is it possbile to add Notification email to the reports that has been created in SSRS. Example:We have set up a report which will be sent to the client through email,Now we want to set a notification email,so if something happened(Successfully run or Any failure) the DBA would be notified.
=>use ssrs time subscription
2-We have setup a report .We deliver this report as a file attachment.Is it possible to re-name the name of this file?Because as default the "reportname+ExecutionDateTime" will be the name of the report.
=>ssrs time subcription
May 20, 2013 at 11:49 am
1 - Yes. All subscription in SSRS are SQL Agent jobs so you can set up your notifications off of the jobs. You'll find the SubscriptionID from the Subscriptions table in the command in sysjobsteps.
2 - Only if you save the report to the file system. If you are using email for delivery then you have no control over the filename.
3 - You could disable the corresponding job to the subscription, but there will be no indication of this in the Report Manager.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply