OraFAQ Forum: Reports & Discoverer » Run report from batch file

Home » Developer & Programmer » Reports & Discoverer » Run report from batch file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Run report from batch file [message #167570]

Fri, 14 April 2006 00:50

juicyapple
Messages: 92
Registered: October 2005

Member

Hi, I want to run oracle report as a schedule task, is it possible to run it with using command in batch file?

can anyone provide some info about this?

Thanks.

Report message to a moderator

Re: Run report from batch file [message #167576 is a reply to message #167570]

Fri, 14 April 2006 02:03

aciolac
Messages: 242
Registered: February 2006

Senior Member

For example you can include next block in Your file and run them from crontab or any sheduler.

sqlplus -s username/password <<EOF > log_name.log
set serveroutput on
--here You can put your SQL command
select *
from dual;
EOF

Report message to a moderator

Re: Run report from batch file [message #167585 is a reply to message #167570]

Fri, 14 April 2006 03:24

juicyapple
Messages: 92
Registered: October 2005

Member

Sorry that I missed out something, I want the report save in text format after generate it, is it possible?

Report message to a moderator

Re: Run report from batch file [message #167586 is a reply to message #167570]

Fri, 14 April 2006 03:49

aciolac
Messages: 242
Registered: February 2006

Senior Member

All data which will return selects, will be saved in file log_name.log.

Report message to a moderator

Re: Run report from batch file [message #167641 is a reply to message #167570]

Fri, 14 April 2006 19:45

juicyapple
Messages: 92
Registered: October 2005

Member

I can change the log_name.log to other file format also? eg. filename.csv

Report message to a moderator

Re: Run report from batch file [message #167650 is a reply to message #167570]

Sat, 15 April 2006 00:48

aciolac
Messages: 242
Registered: February 2006

Senior Member

This is the simply log file - you can write into them all that you want. Also you can rename them as you want.

Report message to a moderator

Previous Topic:	Deploying Oracle report with graphs
Next Topic:	Placeholders and Summing Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 20:22:47 CST 2024