Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORACLE JOBS
Hi
I created a job with sqlplus as follow
#
# declare
# jobnum number;
# begin
#
dbms_job.submit(jobnum,'get_db_freespace',sysdate,'sysdate+(1/24/60*5)',null
);
# end;
#
to run ever 5 mins
the server is setup with
job_queue_processes = 2 job_queue_interval = 60 job_queue_keep_connections = False
If I call the procuder 'get_db_freespace' with sqlplus or procuder-builder
it's working
WHAT CAN BE WRONG WITH MY JOBS?
Etienne
Received on Fri Jan 31 1997 - 00:00:00 CST