RE: Jobs Question

From: Patterson, Joel <>
Date: Mon, 7 Apr 2014 11:32:44 -0400
Message-ID: <C1117B1AA0340645894671E09A7891F715F43E83EF_at_EIHQEXVM2.ei.local>

Become the user that owns the job, then remove it.

From: [] On Behalf Of Scott Canaan Sent: Friday, April 04, 2014 2:17 PM
Subject: Jobs Question

This is Oracle 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 (<>)

(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
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916<>


[]<> [] <!/entint> [] <> [] <>
This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] --
Received on Mon Apr 07 2014 - 17:32:44 CEST

Original text of this message