Locate & Alter Email Addresses for a Report Manager Report Subscription
<p>I'm a brand new Junior SQL Developer. I have inherited several reports, which are on Report Manager. Some of them seem to have subscriptions set up, but they contain invalid email addresses. </p>

<p>I understand I can modify each of these reports and their subscriptions one at a time through Report Manager by clicking the report, going to Manage, Subscriptions, etc.; however, this seems like a huge waste of time and effort and it doesn't offer a very solid solution for the future. </p>

<p>I would much rather spend time on something that makes more sense. Is there some way I can access all of my Report Manager report Subscriptions from SSMS? I'd like to be able to see what email addresses they're hard-coded to right now and then modify that to select from a list of employee emails in our HR database. That way if an email changes later on, or if we want to remove one person from ALL subscriptions it won't involve a ton of time.</p>

<p>Also, does anyone know how to avoid the ridiculous job-naming conventions that seem to come with Report Manager? I don't know what Report "3AC1BB6F-D782-46DD-99F5-CCA1E6257091" is tied to, but if it could be modified to default to something like "ReportName+Microsoft'sTypicalBSNamingCovention", that'd be fine and would make some sense.</p>

<p>I hope that makes sense. Thank you all in advance for sharing your experience and knowledge with me.  :^) </p>