Solved

Scheduling a Report without the SQLAgent

Posted on 2008-06-24
5
184 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

688 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