Re: Jobs Question

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Fri, 4 Apr 2014 18:29:45 +0000
Message-ID: <CF647241.575B5%Mark.Bobak_at_ProQuest.com>

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 - 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-l Received on Fri Apr 04 2014 - 20:29:45 CEST