Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Changing enddate on subscriptions using sql Expand / Collapse
Posted Wednesday, December 5, 2012 9:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 7:48 AM
Points: 1, Visits: 60
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.
Post #1393067
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse