Scheduled reports

I have set up reports to be generated hourly and emailed to me, however the report will run for a few hours and then stop. I have checked the schedule and made sure there is not expiration date. My question is: Is ther anyway is can get report status if the report errors with the error message so that i can track this issue?

Any assistance here would be greatly appreciated.

Regards,
Hi,
As far as I experienced there are few places where we can check the status of a scheduled report.
One of them is the reports' subscriptions tab ( http://reportserver/Reports/Pages/Report.aspx ) when you open the properties page for that report on the reports directory. There exists a status column.
Also when you edit the subscription for that report again on the same page above, you will be redirected to http://reportserver/Reports/Pages/SubscriptionProperties.aspx page. There is the schedule name which is used by the SQL Server instance where the ReportServer databases are installed.

If you go open Jobs list by using SQL Server Enterprise Manager, you can see the job in the list. Again detailed status information for that job can be seen there. Or by opening the job history screen from the context menu.
Or you can check the Event Viewer for the ReportServer service specific messages.
Eralper|||

Hi:

I set up a report that pulls data from the ExecutionLog table from the ReportServer DB.

If there is an error, it can be read from C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles

Regs,

Perry