Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Regenerate SSRS Subscription Agent jobs Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 3:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:11 PM
Points: 94, Visits: 181
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
Post #1489927
Posted Sunday, September 1, 2013 4:45 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:11 PM
Points: 94, Visits: 181
Bump. Anyone?
I don't want to relegate it to the sparsely populated realm of impossibility.
Post #1490497
Posted Monday, September 2, 2013 7:29 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 241, Visits: 2,682
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.
Post #1490618
Posted Monday, September 2, 2013 2:03 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:11 PM
Points: 94, Visits: 181
Excellent I'll try that.
(I have RSScripter - it's brilliant but doesn't do SQL Agent jobs)

Thanks,
signal_runner
Post #1490687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse