Post reply

Regenerate SSRS Subscription Agent jobs

  • August 29, 2013 at 3:26 pm

    #298360

    Hi gurus.

    We have a method in place for disaster recovering SSRS (from a production primary to log shipping secondary). The fail-over process is fairly straight forward, except for one problem: The SQL Agent jobs that run the report subscriptions don't transport with the ReportServer database obviously.

    So is there a script or sproc that can re-generate the SSRS Subscription SQL Agent jobs? (the ones with a GUID for their name)?

    I've searched this forum and online and not found anything to apologies if I've missed something obvious.

    Many thanks,

    signal_runner

  • September 1, 2013 at 4:45 pm

    #1646653

    Bump. Anyone?

    I don't want to relegate it to the sparsely populated realm of impossibility.

  • September 2, 2013 at 7:29 am

    #1646746

    The subscription sql agent jobs should regenerate when you restart the ssrs service. Also, there used to be an RS Scripter tool, but I have been unable locate the download.

  • September 2, 2013 at 2:03 pm

    #1646804

    Excellent I'll try that.

    (I have RSScripter - it's brilliant but doesn't do SQL Agent jobs)

    Thanks,

    signal_runner

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

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