Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
--Get SQL Agent Job names for SSRS Subscriptions
SELECT Schedule.ScheduleID AS JobName,
[Catalog].Name AS ReportName,
Subscriptions.Description AS Recipients,
[Catalog].Path AS ReportPath,
StartDate,
Schedule.LastRunTime
FROM [ReportServer].dbo.ReportSchedule
INNER JOIN [ReportServer].dbo.Schedule
ON ReportSchedule.ScheduleID = Schedule.ScheduleID
INNER JOIN [ReportServer].dbo.Subscriptions
ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID
INNER JOIN [ReportServer].dbo.[Catalog]
ON ReportSchedule.ReportID = [Catalog].ItemID
AND Subscriptions.Report_OID = [Catalog].ItemID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment