Changing enddate on subscriptions using sql

  • Hello Guys,

    I couldn't find any question similar to this before, If it is please excuse and point me to that thread.

    Question :

    I have a report with 300 subscriptions setup for it which are using the local schedule for each of it. The other day we wanted to stop them subscriptions on that report, So we have deleted the jobs in sql server agent. still those reports have been run for some reason, don't know why. So we have changed the end date for each subscription to previous day, so that they won't run next day.

    Now my question, is there a way to update all them end dates when we wanted to put them subscriptions live.

    I have already tried to change the enddate on Schedule table and even after changing the enddate it still doesn't kick in as per the schedule. Obviously changing the enddate on the table doesn't change it in the front end in ssrs. So, I don't know what other options are available to change all of them subscriptions back to live. Please let me know if you think of anything.

    Thank you.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply