Monday 5 July 2010

Find SSRS Subscription Jobs

A helpful query found on Patrick LeBlanc's blog:


The result set returns a list of SQL Server Reporting Services Reports matched to the jobs used to run the report subscriptions. A very helpful query in that SSRS report manager names the regular subscription and data driven subscription jobs based on a uniqueidentifier. This makes it difficult to identify which jobs run which subscriptions when viewing jobs through SQL Server Management Studio.

No comments: