[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Scheduling a Report without the SQLAgent

Posted on 2008-06-24
5
Medium Priority
?
187 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 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

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…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

656 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