dbms_job - makes my head spin

List,
8.1.5 (AIX)
job_queue_processes = 1
job_queue_interval = 10

snp process is running , i checked..

i have a simple stored procedure (tmp)which inserts a number into a table which i submitted as a job..

dbms_job.submit(job_no,'tmp;',sysdate,'sysdate(1/1440'); dbms_job.run(job_no);

the interval is sysdate+1/1440 which calculates to 1 min.

after i submit the job it runs once - baecuase of the dbms_job.run, but then fails to run at the 1 min. interval !!! the NEXT_TIME column IS updated every minute
to reflect the new next_time but the FAILURES increase each time.

what am i missing here...?? Received on Wed Sep 27 2000 - 07:25:03 CDT