Execute SSRS subscriptions manually

USE [ReportServer];
GO 
SELECT
     S.ScheduleID AS SQLAgent_Job_Name
     ,SUB.Description AS Sub_Desc
     ,SUB.DeliveryExtension AS Sub_Del_Extension
     ,C.Name AS ReportName
     ,C.Path AS ReportPath
FROM ReportSchedule RS
     INNER JOIN Schedule S ON (RS.ScheduleID = S.ScheduleID)
     INNER JOIN Subscriptions SUB ON (RS.SubscriptionID = SUB.SubscriptionID)
     INNER JOIN [Catalog] C ON (RS.ReportID = C.ItemID AND SUB.Report_OID = C.ItemID)
WHERE
     C.Name IN('MyReportName'),


--copy SQLAgent_Job_Name from above query into below proc and execute

USE msdb
EXEC sp_start_job @job_name = '92C06E98-08F1-403A-879B-38D650A185FE' --MyReportName

Tags:

Wednesday, September 16th, 2015 SSRS