February 8, 2012 at 7:48 am
I’m looking to find if a instance is interactive or subscription on SSRS report server. Some time we have many reports running and we would like to see if they are subscription or interactive reports.
I can see all the jobs which are running using RunningJobs table on report server and I used to join with Users table to get who is running them. But I could not find any way to know if it is subscription or interactive.
I use ExecutionLog2 to determine what kind of report it is after the reports completes.
So does anybody know how I can find a report if it is subscription or interactive when it is running?
February 8, 2012 at 8:08 am
In the table "ExecutionLog" you'll find a column called "RequestType".
If the value for this column is 0 that means it was run interactive, 1 means run buy a subscription.
[font="Verdana"]Markus Bohse[/font]
February 8, 2012 at 8:26 am
Thank you. But ExecutionLog has data when the report is completed. I wanted to know that when report is running.
But anyway there is field called JobType which has values 0 and 1. So according to your logic, i tested and it is displaying 0 as interactive and 1 as subscription.
February 8, 2012 at 8:45 am
I never really worked with dbo.RunningJobs and since it's not documented you have to be careful, when making such assumptions.
When I just tried to catch a report in dbo.RunningJobs it never showed, even though the report ran for about 30 seconds. So I wonder if it will always display all running reports on your system.
[font="Verdana"]Markus Bohse[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply