Report subscriptions

Is there a way to either query the ReportServer database or view a report within Reporting Services to show all the subscriptions and their next run time? The "My Subscriptions" area only shows when a report was last run for subscriptions I created. Since we'll end up moving dozens of reports from Crystal to SSRS and multiple people will be creating schedules, it'd be handy to have a nice list displaying exactly what's scheduled and when they'll run next.

Any ideas are greatly appreciated.

Thanks

You would have to create an user interface to pull the data from the SQL Server Agent for this.

HTH, Jens Suessmyer.

http://www.sqlserver2005.de
|||

For subscriptions, you can also pull the data from the Subscriptions table in the ReportServer DB.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de