Automation of Jobs in oracle

[Guest_imported]

hi all
Basically i am a sytem admin and here i have come to
have view of you Oracle guys on the following problem.
Infact we have oracle7.x.y..( i dont know the exact version) on Ibm RS6k (AIX).
One of my user logs into Xwindows env. and in Oracle
and inputs his parameters to run his report.when he clicks
Run button ...report processing starts immediately.
Infact what i want to know whether oracle reports in particular and Oracle in general provide any mean to delay
report processing up to specified time....that is if user
inputs his parameters in daytime his report in fact run
in midnight when the system has no load at all.
I cant do that on unix basis b/c i cant find any specific
command in oracle to run the reports so that i can schedule it.
So is there any way to submit the jobs to oracle Database?
and then run them at some later time.
Hope to hear from you all.

 

[najaf]

You can schedule report using reports server with the command line parameter schedule=xxx.
I dont think you can do it without report server.
If you can schedule at operating system level then you can use RWRUN60 command (for reports6.0) to invoke reports thru command line.
I hope it helps
Najaf

 

[MikeJones]

Or you could run a job at midnight that does all the crunching for the report and stores the data in a temp table. The report could then be doing a simple select * from temp_table.

 

[gregburningham]

Yes, further to Mike's response a possible solution would be to
schedule a database job to run using the dbms_job package ...

The report could then select from a temporary holding table the following
morning as Mike suggests.

The package is owned by SYS


Here is the syntax for dbms_job.submit:
----------------------------------------------
procedure submit_interface_jobs is
x binary_integer := 0;
begin
dbms_job.submit(x,'user_package.user_procedure;',trunc(sysdate) + 900/1440, 'trunc(sysdate + 1) + 900/1440' );
end;

--
-- (1440 is the number of minutes in a day !)

-- Note: The above job will be submitted at 15:00 hrs everyday


Cheers
GregB

 

[Byomite]

How can I initiate an Oracle Report from another package without using the SRW etc.
( scenario:- Client PC has a web page with select options to choose from a list of reports, hits a "Run" button which automatically initiates the report on the report server, and then emails the report to the client in PDF format).
Thanks.