SSRS Data Driven Subscriptions Cryptic Job Names

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:

SELECT

            s.ScheduleID Job_Name,

            su.Description Subscription_Description,

            c.Name 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 pleblanc@pragmaticworks.com.

Talk to you soon,

Patrick LeBlanc, founder SQLLunch.com and TSQLScripts.com

Visit www.BIDN.com, Bringing Business Intelligence to your company