Re: Jobs Question

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Fri, 4 Apr 2014 19:43:24 +0000
Message-ID: <CF648354.5765D%Mark.Bobak_at_ProQuest.com>

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.

Thanks,

-Mark

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com<mailto:r.aialavajjala_at_gmail.com>> Date: Friday, April 4, 2014 at 3:38 PM
To: Mark Bobak <Mark.Bobak_at_ProQuest.com<mailto:Mark.Bobak_at_ProQuest.com>> Cc: "srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>" <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>>, "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Re: Jobs Question

Scott,
 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...

http://www.pythian.com/blog/killing-an-oracle-job-dead/

Thanks,

--Rajesh

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

-Mark

From: "srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>" <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> Reply-To: "srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>" <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> Date: Friday, April 4, 2014 at 2:17 PM
To: "oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>" <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>> Subject: Jobs Question

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<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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 04 2014 - 21:43:24 CEST