February 3, 2009 at 9:20 am
I have been tinkering with the Performance Dashboard and other reports in SQL2K5(SP2). They are very handy, but have, what I consider, a major limitation. I can't seem to find a way to automate the execution of these reports. I have a limited (and I believe fixed) configuration that does not include Reporting Services.
Seems you can script most other things. Is there a way to script or otherwise automate the running of these reports with just the SSMS?
February 3, 2009 at 9:45 am
I don't understand what you mean by automation because the SQL Server 2005 installer will not enable SSRS as an option if you are not running IIS in the box. So you need to install IIS and Reporting Services because you cannot render SQL Server 2005 reports without the Asp.net runtime correctly configured in IIS and your ReportServerDB and ReportServerTempDB running so your reports are processed and rendered in IIS.
Kind regards,
Gift Peddie
February 3, 2009 at 9:58 am
What I was hoping was to have an agent job create the report, save the output to excel (which the report suports manually), then dbmail it to me.
Seems I won't be able to do that.
February 3, 2009 at 10:05 am
In SQL Server 2005 and above everything in the BI area require an instance of the feature like SSRS or SSIS running before you can run code related to that feature.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply