Reporting Services 2005/2008 Job Lookup

Ever needed to manually run a report from Reporting Services, following the rules of a subscription, but don’t want to go through the effort of editing an existing subscription, letting it run, then editing it back or creating a new one?

The following T-SQL Statement, when ran against the Reporting Services Database will allow you to see the SQL Agent Job Name, and additional details about the subscription, which you can then run directly from Management Studio, or any application that allows you to run SQL Jobs:

SELECT Schedule.ScheduleID [Job Name],
      Subscriptions.Description [Subscription Description],
      Subscriptions.DeliveryExtension [Subscription Type],
      [Catalog].Name [Report File],
      [Catalog].Path AS [Report Location]
FROM   ReportSchedule INNER JOIN
      Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID INNER JOIN
       Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID INNER JOIN
       [Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID AND Subscriptions.Report_OID = [Catalog].ItemID

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s