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

Hi @Matt Tobino,

Open SSMS:

1. In Object Explorer, expand a report server node.
2. To verify the shared schedule isn't currently used by reports, Expand the Shared Schedules folder, right-click the schedule and select Properties.

And then you may edit the schedule easily and check which report are using this schedule.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.