Solved

Scheduling a Report without the SQLAgent

Posted on 2008-06-24
5
179 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
sorry , I meant
"Report Scheduler is NOT supported in SQL Express 2005."
0
 
LVL 2

Author Closing Comment

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

12 Experts available now in Live!

Get 1:1 Help Now