Send Notification for windows sharing subscriptin in SSRS

Question

Hi all,

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

Nagarajan.V

Answer 1

Hi Nagarajan.V,

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

Regards,

---

Mike Yin
TechNet Community Support