Re: Jobs Question
- From: Mark Bobak <Mark.Bobak@xxxxxxxxxxxx>
- To: "srcdco@xxxxxxx" <srcdco@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 4 Apr 2014 18:29:45 +0000
I believe you need to be connected as the user who created the job.
-Mark
From: "srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>"
<srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>>
Reply-To: "srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>"
<srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>>
Date: Friday, April 4, 2014 at 2:17 PM
To: "oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>"
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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
Other related posts:
