Musings on Data

A blog for data, apis, and all things Power BI by Lukasz Pawlowski.

December, 2005

  • Musings on Data

    Monitoring Subscription Status (also calling RS SOAP methods from inside reports)

    While posting on the Reporting Services forum, I came across a post by some folks looking to know how to automatically find out that a subscription had failed to run. Right now, the way the RS tools are, there is no way to do this automatically without calling a SOAP method - ListSubscriptions. These folks were DBAs who wanted to monitor RS without needing to build an entire application to do so. The solution they were trying was to access the report server database directly to read values out its tables. They weren't impressed when I told them that MS does not support direct access to the report server database other than for getting data out of the execution log. There are several ways to get around the lack of subscription monitoring...
Page 1 of 1 (1 items)