Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> dbms_job failures

dbms_job failures

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 16 Jul 2001 17:51:15 GMT
Message-ID: <9iv9ij$9m9@dispatch.concentric.net>

I have a procedure that should be run daily. This is how I submitted the job:

dbms_job.submit( :jobid,

'FIT_DBA.AMS_JOB.PURGE_AMS_TAB;',

                              trunc( sysdate ),

'round( trunc( sysdate ) + 1.20, 'HH' )');

I've had it in the queue a number of days and noticed that Failures = 13. When I try to run it using,

    dbms_job.run(61)
I get an error ORA-12011 'execution of one jobs failed.' I also have errors in sys.dbms_ijob line 405 and sys.dbms_job line 267.

The next_date is calculated and displayed correctly which according to O'Reilly, 'Oracle Build Packages' should not happen if the job fails.

If I run this code
  begin

        FIT_DBA.AMS_JOB.PURGE_AMS_TAB;
  end;
the procedure runs without error.

The job is submitted and run under user 'FIT' which has rights to run any procedure.

Why would the job fail?

Thanks.

--
Jim Poe (jpoe_at_fulcrumit.com)
Received on Mon Jul 16 2001 - 12:51:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US