I want to enable a monitoring system that we have (ServersAlive) to periodically check a report in SQL Reporting Services 2008 automatically. I have it setup so that it checks a URL similar to the following and sees if the word "Failure" appears anywhere in the XML file:
This works perfectly when I set it up and continues to work for a period of time only after I check the actual report by through the RS interface by going to the following link:
The problem is that after a certain period of time (normally a few hours), the first link stops working and starts returning an error stating "Execution '2qqtn2yhtrejup452tvznt55'
cannot be found (rsExecutionNotFound)". It's like there is a timeout issue or somehow the second link only works for a period of time after I go to the first link (like the first link is only accessing a snapshot of the report and not generating the report on the fly).
Basically, I need a way that I can point our monitoring application to a URL that generates a report on the fly, perferably in XML format. I can't just point it to the second link, because the HTML from that page is just the report rendering viewer and not the report itself that would have the report data (and the word "Failure") in it. Any help is appreciated.