Post reply

Managing the subscription of Reports(Created by SSRS) by TSQL

  • May 25, 2010 at 5:37 pm

    #232870

    We have some reports that have been created by SSRS,Is there any way that we can manage these reports by TSQL.For instance we want to create a webpage so through that the user can set the subscription of reports(like :when should the report runs,...),instead of going to SSRS WebSite

    I would appreciate if someone help me on this.

  • May 28, 2010 at 4:34 am

    #1173821

    We are managing the subscriptions by using the custom assembleys(dll).

    Thanks

    Veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • April 28, 2011 at 5:30 pm

    #1317626

    Hi Veeren,

    I have setup subscriptions, the problem is once you dont require say half of them, you cannot really disable them (if you disable the job or the schedule once someone changes the schedule date in subscription for example the subscription re-enable's the job and schedule. From my experience there is only 2 ways to prevent the subscription going out again -

    1. jippo method - change ownerid to a disabled account for those subscriptions you dont want to go out.

    2. best method - go to report manager, select report, select all subscriptions, click delete.

    Is there not a better way to setup subscriptions so you can enable / disable via a script and not create any subscriptions via report manager.

Viewing 3 posts - 1 through 2 (of 2 total)

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