Forum Discussion
Joey1974
Jan 10, 2025Copper Contributor
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.
No RepliesBe the first to reply