ORA-23421: job number 141 is not a job in the job queue
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-23421: job number 141 is not a job in the... Expand / Collapse
Message
Posted 5/24/2009 1:18:35 PM Post #131
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
Hi,

I was logged in as SYS and trying to remove a job but was getting the following error :


SQL> execute DBMS_JOB.REMOVE (141);
BEGIN DBMS_JOB.REMOVE (141); END;

*
ERROR at line 1:
ORA-23421: job number 141 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 171
ORA-06512: at line 1

Then after some reseach, I found how to remove the job that is owned by another user:

SQL> EXECUTE SYS.DBMS_IJOB.REMOVE (141);

PL/SQL procedure successfully completed.


Hope this helps.

 

Thanks,

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:25am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.055. 7 queries. Compression Disabled.