Posts

is there a way to query future SSRS subscription schedules?

https://stackoverflow.com/questions/25943877/is-there-a-way-to-query-future-ssrs-subscription-schedules   has several T-SQL examples

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

Report launcher to run SSRS report subscriptions on demand

https://www.mssqltips.com/sqlservertip/3078/report-launcher-to-run-ssrs-report-subscriptions-on-demand/  

How to easily identify a scheduled SSRS report

https://www.mssqltips.com/sqlservertip/1846/how-to-easily-identify-a-scheduled-sql-server-reporting-services-report/  

SSRS Subscriptions (What goes on "under the hood")

https://techcommunity.microsoft.com/blog/coreinfrastructureandsecurityblog/ssrs-subscriptions-what-goes-on-under-the-hood/370746   SELECT n.SubscriptionID ,c.Name AS ReportName ,c.Path AS ReportPath ,u.UserName AS SubscriptionOwner ,n.ExtensionSettings ,n.NotificationEntered AS QueuedSinceTime ,n.ProcessAfter ,n.SubscriptionLastRunTime ,n.DeliveryExtension FROM dbo.Notifications n WITH (NOLOCK) INNER JOIN dbo.CATALOG c WITH (NOLOCK) ON n.ReportID = c.ItemID INNER JOIN dbo.Users u WITH (NOLOCK) ON n.SubscriptionOwnerID = u.UserID WHERE n.ProcessStart IS NULL AND ( n.ProcessAfter IS NULL OR n.ProcessAfter < GETUTCDATE() ) ORDER BY n.NotificationEntered

Subscription Settings and a File Share Account (Report Server Configuration Manager) Has Powershell Sample

https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/subscription-settings-and-a-file-share-account-configuration-manager?view=sql-server-ver17