View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
When you create and schedule a Data Driven Subscription for a SQL Server Reporting Services (SSRS) report a job is created with a very meaningless name. The name is actually a uniqueidentifier and is stored as such in the dbo.Schedule table in the ReportServer database. I was recently asked if it was possible to use the Job Name to identify the Report associated with the job. After a little digging I was able to produce the following query, which associates the Job Name with the Report Name:
FROM dbo.Schedule s
INNER JOIN dbo.ReportSchedule rs
ON s.ScheduleID = rs.ScheduleID
INNER JOIN dbo.Catalog c
ON rs.ReportID = c.ItemID
INNER JOIN dbo.Subscriptions su
ON rs.SubscriptionID = su.SubscriptionID
The ReportServer database is a wealth of knowledge. If you support Report Server deployments I recommend that you spend some time becoming familiar with the database schema. If you have any questions or concerns regarading this topic please feel free to email me at email@example.com.
Talk to you soon,
Patrick LeBlanc, founder SQLLunch.com and TSQLScripts.com
Visit www.BIDN.com, Bringing Business Intelligence to your company
Other posts by PatrickLeBlanc