Using dbms_job package

Just further to discussion -thanks to everyone who sent me replies =)

I'm still having problems running every 2 minutes (interval deliberately kept small just for testing purposes but set higher should still work!)

Job just sits in job queue unless prodded (ie. dbms_job.run), I know this because my test procedure 'fred' writes to a file (utl_file) with date/time stamp.

declare
  job# integer;
begin
  dbms_output.put_line('submit time: '||to_char(sysdate,'hh24:mi:ss'));   dbms_job.submit(job#,'fred;',sysdate,'sysdate+2/60/24');   commit; -- <<<<<<<<< new improved with commit!!!   dbms_output.put_line(job#);
  dbms_output.put_line('finish time: '||to_char(sysdate,'hh24:mi:ss')); end;

Spec's on system: HP-UX 10.20 Box running Oracle 7.3.2.2.0

init.ora settings:

job_queue_processes=2
job_queue_interval=60
job_queue_keep_connections=false

I've checked the Oracle logs as suggested but nothing with current date in that particular directory exists!

Something smells fishy,

Any correspondance 'really' appreciated.

• Mark.

-- 
/******************************************************\


* Mark Pether                 email: markap_at_bom.gov.au *

* Bureau of Meteorology       phone: 03 9669 4709      *

* National Climate Centre     fax:   03 9669 4515      *

* GPO Box 1289K Melbourne,                             *

* Victoria 3001 Australia.                             *

\******************************************************/