Posts

Showing posts from June, 2025

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  

Enhancing Customer Experiences with Subscriptions in SSRS

https://www.sqlshack.com/enhancing-customer-experiences-with-subscriptions-in-ssrs/  

File Share Delivery Settings

https://learn.microsoft.com/en-us/sql/reporting-services/report-server-web-service/net-framework/reporting-services-delivery-extension-settings?view=sql-server-ver16  

SSRS Failed Subscription Alerting

  https://www.sqlshack.com/ssrs-failed-subscription-alerting/

SSRS Processing: 0 processed of 251 total; 0 errors on data-driven report

https://learn.microsoft.com/en-us/answers/questions/1162118/ssrs-processing-0-processed-of-251-total-0-errors  

create data driven subscription schema error

Google search:   https://www.google.com/search?q=create+data+driven+subscription+schema+error

05-Parse Multi-Value Parameters with OPENJSON

https://sqlserverbi.blog/05-parse-multi-value-parameters-with-openjson/  

Monitoring and Troubleshooting Subscriptions

https://learn.microsoft.com/en-us/archive/blogs/deanka/monitoring-and-troubleshooting-subscriptions