Post reply

Is there any way to stop some subscriptions OR all subscriptions?

  • September 12, 2011 at 4:38 pm

    #390389

    Hello,

    Is there any way to stop some subscriptions OR all subscriptions? I do not want to stop sql agent service.

    Thanks in advance,

    BMR

  • September 13, 2011 at 7:38 am

    #1380621

    You can disable the individual agent jobs of your subscriptions.

  • September 13, 2011 at 1:04 pm

    #1380890

    No. I want to disable more than one job at a time.

  • September 13, 2011 at 10:21 pm

    #1381037

    I think that the following will give you the code you need to disable all scheduled reports

    select 'exec msdb.dbo.sp_update_job @job_name = ''' + CONVERT (VARCHAR(50),RS.ScheduleID) + ''', @enabled=0'

    from dbo.ReportSchedule RS

  • November 17, 2011 at 1:33 pm

    #1409508

    happycat59 answer with script - not sure if it will work.

    from my experience with subscriptions, the best way to prevent them from running is to open report manager (web page of report server), open the report, click properties, select the subscriptions to delete, click delete. all other mehods look like they work (disable or delete job), but start sql agent service and you will find out they have gone out again.

    the best is not to create subscriptions via report manager. lets say you have 350 subscriptions, imagine how long it takes to create each of them (not to mention each subscriptions might have 20 email addresses). now you are asked to delete 150 of them, a month later asked to re-instate 120. you get where I am going with this. wish Microsoft created an add-on to SSRS which automates this task in SSRS.

Viewing 5 posts - 1 through 4 (of 4 total)

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