Can standard reports in SQL Server 2005 be scheduled?


The Standard reports can be used to generate various reports for server and database level in SQL Server 2005.

I am trying to find out whether these reports can be automated i.e. can these standard reports be generated automatically and scheduled in a SQL job.

I would also like to know whether they can then be emailed, maybe as an attachment (XLS/PDF) or just sent as part of the email?

Any help would be highly appreciated.

more ▼

asked Mar 30, 2010 at 09:00 AM in Default

avatar image

Mandar Alawani
376 40 43 48

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

The reports that are accessed from the SSMS object explorer are rdl files like any other report, they take values from the point in the tree where you right click as parameters to give you data relevant to your selection.

It would be possible to locate a copy of these reports to a report server and schedule/email/export to file share as with any other report, so long as you provide values for the parameters.

you can get the set of Standard Reports from this blog - http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS-Reports-3.aspx

more ▼

answered Mar 30, 2010 at 09:25 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 30, 2010 at 09:00 AM

Seen: 2769 times

Last Updated: Mar 30, 2010 at 09:00 AM

Copyright 2018 Redgate Software. Privacy Policy