Automation of jobs in oarcle

[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.
regds

Sunil Anand

 

[THoey]

There is a package in Oracle called DBMS_JOBS. There is a message thread in the Oracle: Oracle 8 forum that talks about removing a scheduled job and I think they showed an example of how they created the job(thread186-48230). You would have to look at the documentation (probably from Oracle's site) to get the instructions for using DBMS_JOBS...

HTH

Terry M. Hoey
th3856@txmail.sbc.com

Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?