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
Solved

Scheduling a Report without the SQLAgent

Posted on 2008-06-24
5
182 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Compare data between two databases 16 109
passing parameter in sql procedure 9 65
MS SQLK Server multi-part identifier cannot be bound 5 41
Parse this column 6 23
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

789 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