Monitoring SSRS Reports and Subscriptions
Interpreting data in ReportServer database
Observations from SSRS 2008 R2
Subscriptions
table dbo.Subscriptions.
InactiveFlags
There’s no way to disable a subscription from SSRS UI though articles suggest setting InactiveFlags to 1 will achieve this.
- 0 : schedule is active.
- 8 : “One or more report parameters have an invalid parameter value.” (text displaed in subscription editor)
- 16 : “An unkown parameter was found.” (text displayed in subscription editor). i.e. a parameter name was set that no longer exists in the report specification.
Schedules
table dbo.Schedule
Column | Description | |
DaysOfWeek | Bitmap. Sun = 1 … Sat = 64 All days = 127 |
|
WeeksInterval | 1 for Daily | |
Month | Bitmap for months | |
MonthlyWeek | nth week of month or Null |
|
Recurrence Type | 1 : Once 2 : Hourly 3 : [not yet achieved] 4 : Day / Week 6 : Month |
|
Re-triggering Scheduled Reports
This is the code that appears in the report-initiating Job.
EXEC ReportServer.dbo.AddEvent@EventType=‘TimedSubscription’,@EventData=‘<SubscriptionID>’
Values for EventType:
- Timed Subscription : individually scheduled subscription for a single report.
- SharedSchedule : this job triggers a shared schedule.