ORACLE JOBS

From: Etienne F de Villiers <dvillie_at_sapo.co.za>
Date: 1997/01/31
Message-ID: <01bc0f40$60978e80$8e0608a5@dvillie.sapo.co.za>#1/1

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