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 run on the specified date store in some table in the database.
Is it possible to run another job to use sp_update_job to disable the job when date is find in the table, and
enable the job when the date is not find in the table.
Because the SSRS's job contain a remarks that "modify this job will make database incompatible", im not sure
is it work.
thanks in advance.
2 Replies
Docs on data driven subscriptions:
Data-driven report subscription is only available in the Enterprise edition; the OP uses Standard Edition.
Yes, it's possible to modify the SSRS job, but you should be carefully with it.
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
