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.