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
ERMAHBLERG 