RE: Jobs Question
- From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
- To: "srcdco@xxxxxxx" <srcdco@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Apr 2014 11:32:44 -0400
Become the user that owns the job, then remove it.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Scott Canaan
Sent: Friday, April 04, 2014 2:17 PM
To: 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
--
Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916
www.entint.com<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>
[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>
[http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg]
<http://twitter.com/#!/entint>
[http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg]
<http://www.linkedin.com/company/18276?trk=tyah>
[http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg]
<http://www.youtube.com/user/ValueofIT>
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]
Other related posts:
