SSRS - Add end date for all SSRS subscriptions

• pwalter83

  SSChampion

  Points: 14575

  More actions

  December 9, 2022 at 3:13 pm

  #4123854

  Hi,

  Could you please advice if it is possible to add an end date for all the SSRS report subscriptions using reportserver query.

  We have more than 500 subscriptions for which I need to add an enddate so they would not run after that date and it would be very tedious to do them one by one.

  Thanks in advance for your help.

   

   

• Jeffrey Williams

  SSC Guru

  Points: 90304

  More actions

  December 10, 2022 at 3:16 pm

  #4124152

  Take a look at the Powershell tools for SSRS - you may be able to use those to update the schedule end dates.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs