Monday, March 18, 2013 2:41 PM
Currenlyt i am subscribing the report by using windows sharing option in the SSRS 2008.
i wanted to know is there any way to send the notification to user's once the report subscription is succesfull.
thanks in advance
Wednesday, March 20, 2013 6:58 AMModerator
If I understand correctly, you create a subscription that uses the Windows File Share delivery method, and you want to send notifications to uses if the subscription runs successfully.
In Reporting Services, each scheduled subscription will create a corresponding SQL Server Agent job. So, you can create a notification on the target job so that it sends notifications to users after the job runs successfully.
To get the job name for a specific subscription, we can use the following query:
Select * FROM ReportServer.dbo.[Subscriptions] Subscriptions INNER JOIN ReportServer.dbo.ReportSchedule R ON Subscriptions.SubscriptionID = R.SubscriptionID INNER JOIN msdb.dbo.sysjobs J ON Convert(nvarchar(128),R.ScheduleID) = J.name INNER JOIN msdb.dbo.sysjobschedules JS ON J.job_id = JS.job_id
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, March 24, 2013 1:07 PM