Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

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:


            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

Talk to you soon,

Patrick LeBlanc, founder and

Visit, Bringing Business Intelligence to your company


No comments.

Leave a Comment

Please register or log in to leave a comment.