Hi Chuan, The views dba_jobs, user_jobs show information about the jobs.
It will be removed after the next execution. Once happen to me and the job had to broke it before remove it. The experts of the list can show more light about the subject. Luck, -----Original Message----- Sent: Friday, 22 February, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.remove to remove one job, later on, I check it using user_jobs, it's still there. Thus issue dbms_job.remove again, this time, this execution seems hung there. I log into sys and issue dbms_job.remove, I got the following error ORA-23421: job number 41 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 525 ORA-06512: at "SYS.DBMS_JOB", line 166 ORA-06512: at line 2 Could anyone tell me why this happens? or is there any dict view to check the job queue? Thanks in advance, Chuan Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).