Home Forums Reporting Services Reporting Services Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent RE: Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent

  • If you look in the ExtensionSettings column of the Subscriptions table, there is an XML string that contains the relevant settings for the delivery extension. In this (email) case, there should be a To element with sub element of Value which contains the string of (semi-colon seperated) email addresses. With a little XML manipulation or perhaps even some regex (regular expressions) you could pull this out quite easily. You would probably want to look at the field DeliveryExtension and filter to ensure you're only looking at ReportServerEmail subscriptions.

    HTH,

    Steve.