DBMS_JOB and Reports

[TaTips]

Hi:

Is it possible to schedule a job on the DB to run a Report 6i object every month, for example. We are using 6i (c/s) on an 8i(8.1.7). So the benefits to be gained from the reports server functionality is sadly out of our reach.

Thanks,
Pradeep

 

[Andthereyouare]

Yes, it's possible to schedule a report to run every month, you can even run it based on something that gets populated in the DB. Like a month-end report or something You need a form to launch the report to schedule it on the report server though. Are you looking to know how to do this?

 

[sem]

You may call any report in batch mode. Just pass a number of additional parameters along with module name and connect string:
paramform=NO batch=YES destype=PRINTER etc.

Regards, Dima

http://seminihin.narod.ru