Forum Discussion

Joey1974's avatar
Joey1974
Copper Contributor
Jan 10, 2025

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

Resources