Forum Discussion
SSRS subscription
Hi all, I hv a question about SSRS subscription under mssql 2022 STD, I saw when i subscript to a report, it will create a job under SSMS jobs. I would like to manage the report subscription not r...
Messing with the job is going to be awkward and hard to document for other or future admins. I'd say use a data driven subscription, have it check the date table to see if the current date is one it's ok to send the subscription. That way you could change when it sends just by adjusting the date table to put in more do or do not send flags (or edit the data driven subscription). Docs on data driven subscriptions: https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions?view=sql-server-ver17