Jobs Question
From: Scott Canaan <srcdco_at_rit.edu>
Date: Fri, 04 Apr 2014 18:17:27 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FE82DAA_at_ex03mail02.ad.rit.edu>
This is Oracle 11.2.0.3 on Linux 6.
Date: Fri, 04 Apr 2014 18:17:27 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D73FE82DAA_at_ex03mail02.ad.rit.edu>
This is Oracle 11.2.0.3 on Linux 6.
I can see a job in dba_jobs that is throwing an error every day at around the same time.
1 4217 AXIS AXISPKG AXISPKG 4/5/2014 10:07:17 AM 10:07:17 0 N null 13 AXIS_JOB.RUN_QUEUED(4217);
I've talked to the vendor and they've said go ahead delete it. When I try to delete it via dbms_job.remove, I get:
SQL> exec dbms_job.remove(4217);
BEGIN dbms_job.remove(4217); END;
*
ERROR at line 1:
ORA-23421: job number 4217 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 770 ORA-06512: at "SYS.DBMS_JOB", line 180 ORA-06512: at line 1
How do I get rid of this job?
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 04 2014 - 20:17:27 CEST