Solved

Scheduling a Report without the SQLAgent

Posted on 2008-06-24
5
180 Views
Last Modified: 2010-04-21
I am trying to schedule a report to run in SQL Server 2005 Express. I realize that the SQL Agent is not included and scheduling is more or less not possible. Is there any way to fire a report and export it via an SQL statement?

My plan is to write some SQL which executes a report, save the SQL and access it thru windows task scheduler and SQLCMD.exe. I am currently doing this with my scheduled backups and other maintenance scripts. But I need to be able to schedule a report as well.
0
Comment
Question by:MapleMale
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:elimesika
ID: 21860859
HI

1) write your SQL to a file , lets say report.sql

2) write report.cmd batch file that as

sqlcmd -S <server> -d <db> -U <user> -P <password> -i report.sql

3) schedule report.cmd  using windows scheduler
0
 
LVL 2

Author Comment

by:MapleMale
ID: 21860910
Thanks for the response elimesika!

Unfortunately my report is not really just TSQL. I'm talking about an ssrs *.rdl file (ssrs report). I would like to have it run automatically and export to say something like PDF or XLS.

I know this is possible in the full version of SQL Server 05. But I'm sure there must be a work around way to do it in SQL Express?
0
 
LVL 19

Expert Comment

by:elimesika
ID: 21861003
Yes , Report Scheduler is supported in SQL Express 2005.
However , XML is fully supported so you can write a SQL that outputs results as an XML file


see
http://www.eggheadcafe.com/articles/20051130.asp
0
 
LVL 19

Accepted Solution

by:
elimesika earned 500 total points
ID: 21861013
sorry , I meant
"Report Scheduler is NOT supported in SQL Express 2005."
0
 
LVL 2

Author Closing Comment

by:MapleMale
ID: 31470389
Thanks! I think this is at least pointing me in the right direction.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now