Home » RDBMS Server » Server Administration » dbms_job.broken ORA-23421 (merged)
dbms_job.broken ORA-23421 (merged) [message #393734] Tue, 24 March 2009 03:55 Go to next message
Messages: 10
Registered: November 2008
Junior Member
I have received the below error while i am placing the below job online from broken status.

exec dbms_job.broken(4046,false);

Error on line 0

ORA-23421: job number 4046 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 248
ORA-06512: at line 2

please suggest the possible answers.
How to bring the particular job online.


Re: dbms_job.broken ORA-23421 [message #393737 is a reply to message #393734] Tue, 24 March 2009 04:14 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Why duplicate post?

You need to help us by following the Posting Guidelines as stated below.

ORA-23421: job number string is not a job in the job queue
Cause: There is no job visible to the caller with the given job number.
Action: Choose the number of a job visible to the caller.


[Updated on: Tue, 24 March 2009 04:18]

Report message to a moderator

Previous Topic: Available disk space
Next Topic: Downgrade from Enterprise to Standard Edition
Goto Forum:

Current Time: Tue Oct 25 23:50:07 CDT 2016

Total time taken to generate the page: 0.24956 seconds