x

Can standard reports in SQL Server 2005 be scheduled?

Hi,

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

Mandar Alawani gravatar image

Mandar Alawani
376 33 39 44

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

1 answer: sort oldest

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

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

thank you very much for this...i was able to successfully deploy standard reports to SSRS using RDL files.
Apr 01, 2010 at 05:30 AM Mandar Alawani
(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x94

asked: Mar 30, 2010 at 09:00 AM

Seen: 2531 times

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