Re: Jobs Question

From: Mark Bobak <>
Date: Fri, 4 Apr 2014 19:43:24 +0000
Message-ID: <>

Thanks Rajesh. I wasn't aware of that. I'd noticed dbms_ijob package before, but never really thought much about it, why it was there, or how it could be used.

The ability to kill jobs without regard to logged in user, is useful indeed.



From: Rajesh Aialavajjala <<>> Date: Friday, April 4, 2014 at 3:38 PM
To: Mark Bobak <<>> Cc: "<>" <<>>, "<>" <<>> Subject: Re: Jobs Question

 Mark is correct - you can only drop jobs that belong to the user that created them - however - there is a workaround...

This job may be removed using the "undocumented" dbms_ijob PL/SQL package...the functionality exists for SYS to drop a job belonging to any database user...



On Fri, Apr 4, 2014 at 2:29 PM, Mark Bobak <<>> wrote: I believe you need to be connected as the user who created the job.


From: "<>" <<>> Reply-To: "<>" <<>> Date: Friday, April 4, 2014 at 2:17 PM
To: "<>" <<>> 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<tel:%28585%29%20475-7886> - work                (585) 339-8659<tel:%28585%29%20339-8659> - cell
"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer

-- Received on Fri Apr 04 2014 - 21:43:24 CEST

Original text of this message