September 8, 2014 at 5:12 pm
Hi ,
Is there a way to check if a subscription was sent out. I have a report with a data driven subscription setup which sends five subscription emails to different accounts. I need to find out if the subscription was sent out to each one of those accounts on a particular day. Please let me know it is possible to find out?
Thank you,
Veena
September 9, 2014 at 8:00 am
I think you can see these in the following table in the ReportServer database
[dbo].[ExecutionLog3]
Look for RequestType of 'Subscription'
October 10, 2014 at 3:47 pm
Hello, Thank you the response.
The executionLog3 table seems to have all the executions of that report. If I have two subscriptions set up on the same report, how do I make sure each of those subscriptions ran already on a particular day?
I dont see a subscription name on that table.
Thank you,
Praveena
October 14, 2014 at 10:17 am
The view has a start time and date so could base a query off this and the expected run time for the subscriptions. You could possible join the view to the ReportServer.dbo.Subscriptions table where the ItemPath column of the ExecutionLog3 view matches the Path column of the Subscriptions table. You can then get the Subscription name from this table.
October 14, 2014 at 12:25 pm
For my case, the expected run time is hard to know because each subscription is scheduled to run every hour. If the ETL process finishes by that hour, then the subscription is sent out and then it stops for the day based on the query. I am using the parameters for right now to differentiate between the subscriptions. But I wanted to know if there is anything simpler than using the parameters. With the parameters, there would be a problem when the parameters are same but probably groups are different.
Thank you,
Praveena.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply