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
oraclevijay
Messages: 10
Registered: November 2008
Junior Member
Hi,
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
begin
dbms_job.broken(4046,false);
end;

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.

Thanks
vijay.s

Report message to a moderator

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

Why duplicate post?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Quote:
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.



Thanks

[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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:59:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.