How to get a list of SSRS schedules for subscriptions
https://www.sqlservercentral.com/forums/topic/how-to-get-a-list-of-ssrs-schedules-for-subscriptions
SELECT
S.ScheduleID,
C.[Path] ObjectPath,
U.UserName,
SB.[Description],
S.StartDate,
S.LastRunTime
FROM ReportServer.dbo.ReportSchedule RS
INNER JOIN ReportServer.dbo.Schedule S ON S.ScheduleID = RS.ScheduleID
INNER JOIN ReportServer.dbo.[Catalog] C ON C.ItemID = RS.ReportID
INNER JOIN ReportServer.dbo.Subscriptions SB ON SB.SubscriptionID = RS.SubscriptionID
INNER JOIN ReportServer.dbo.Users U ON U.UserID = SB.OwnerID
Comments
Post a Comment