Share via

Subscription

Joey Tsui 0 Reputation points
2025-01-10T09:50:11.9933333+00:00

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.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,968 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Javier Villegas 900 Reputation points MVP
    2025-01-12T00:03:47.0866667+00:00

    Hi @Joey Tsui

    instead of using T-SQL I recommend you to use Powershell Get-RsSubscription and Set-RsSubscription

    use this as reference

    https://stackoverflow.com/questions/54636884/amend-ssrs-subscriptions-with-t-sql

    Regards

    Javier

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.