SSRS Reusing a Shared Schedule through database

Question

Hello! I am running some tests with MSSQL and SSRS where I have some shared schedules that expired last year. I used this update statement to try and bring those reports back to life to run.

UPDATE Schedule

SET 

    StartDate = '2025-01-09 00:00:00.000', 

    EndDate = '2025-01-10 00:00:00.000'

WHERE ScheduleID in( 

'XXX' -- Schedule 1

,'XXX' -- Schedule 2

,'XXX' --  Schedule 3

,'XXX' -- Schedule 4

,'XXX' -- Schedule 5

);

This failed and the reports remained expired. When I went into the web interface, I saw it said they were Expired. After some digging this seemed to be connected to the State field so I set it to 1, which appeared to be Active/Enabled on other schedules.

UPDATE Schedule

SET 

    StartDate = '2025-01-09 00:00:00.000', 

    EndDate = '2025-01-10 00:00:00.000',

State = 1

WHERE ScheduleID in( 

'XXX' -- Schedule 1

,'XXX' -- Schedule 2

,'XXX' --  Schedule 3

,'XXX' -- Schedule 4

,'XXX' -- Schedule 5

);

If that worked, I would not be writing this LOL. Anyways, when that failed, I went back to the web interface and just back dated the start dates by 1 day and they came back to life to run once more. However this did not last long as it seems after one run they went back to being expired. How can I automate bring these Shared Schedules back to life?

Answer 1

Hello,

Thank you for posting in Microsoft Community forum.

From the description above, I understand your question is related to SQL Server Reporting Services.

Since there are no engineers dedicated to this topic in this forum. To be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

Here is the link for Q&A forum.
Questions - Microsoft Q&A

Click the "Ask a Question" button in the upper right corner to post your question and select tags related to your products.

I hope the information above is helpful.

If you have any questions or concerns, please feel free to let us know.

Best Regards, Karlie Weng