MOSS 2007 Powershell to run Report Builder Reports RDL

Question

MOSS 2007: Client has a library of reports created in Report Builder and SharePoint. These ".RDL" files are stored in specific folders inside a Report Library.

Are there powershell commands that will allow for this?

1. Given a specific Report Library

2. For each report definitions "RDL" in Library

3. If the report definition last run failed, or it's last successful run is more than X days ago

4. For each subscription inside the RDL

5. Run the subscription Once

Answer 1

It is possible to iterate through what you want, but the actual controlling of the running of subscriptions occurs through the SQL Agent jobs.

So while you can iterate a SharePoint document library easily enough and List the subscriptions through the Reporting Services web services (I would start here with trying to call it through powershell), you are not going to be able to manipulate the SQL Agent jobs.

You may get better mileage from creating a stored procedure and re-running any failed jobs directly from the SQL Server.