Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Navin
Starting Member
1 Post |
 Posted - 2004-01-23 : 00:32:04
|
| hi,I need to open an IE browser window for a report whose querystring I have. I need to open the page in the browser through the SQL Server Agent Job Scheduler. In the SQL Server Agent while defining job steps for a job I have selected the type of 'Command' as Operating System Command (CmdExec) . The general idea that I have is that we can execute anything in the section that we can execute on the command prompt. I need some insight on how to go about this.This is not going to be an interactive thing. It will open up a report which will be then sent ot the printer (automatically ) to be printed out, like a day end process in a bank . It is something that needs to be scheduled so that the printing of the data starts at the scheduled time. Im looking at the windows scheduler option . The querystring for the reports is being stored in the database , so I am looking for a way to solve that issue.regards,Navin |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-01-23 : 00:32:54
|
| wtf?This is a pretty bad idea. No offense, but this is the typeof thing that programmers think up when there are no DBAs to keep things straight. Find another way to accomplish this. Like running the report from something like crystal reports, or MS reporting services, or business objects or whatever.-ec |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-01-23 : 09:07:24
|
| I've seen Browser "Script Engines" which allow you to schedule browser jobs.Don't have a URL to any at the moment. |
|
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2004-01-23 : 11:20:42
|
| If anything this should be something run off of the local database server. Try looking into emailing the report, instead of printing it every day. That way the people who want a paper copy can print it themselves.PS. Reporting services is still in beta, so I would not use that option for any production project. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
|
|
Opening an IE Browser Window through SQL Job Sched