RE: dbms_scheduler

Joel, the code snippets you included don't provide quite enough
information to fully analyze the situation.  In particular, it's not
clear whether the whse_extract job you created will be executed once and
(by default) dropped when completed, or whether it will be set up as a
repeating process.  If the former, then of course you won't be able to
drop it (because it's already gone), nor will you find any corresponding
entry in the ALL_SCHEDULER_JOBS view.  However, the job history will be
saved in the logs, which you seem to be able to find.

From the evidence provided, it seems as though the job you are creating
is, in fact, a run-once-and-drop item.  Does this sound plausible? 
===================================== 
Jim Silverman 
Senior Systems Database Administrator 
Solucient, LLC - A Thomson Company 
Telephone:   734-669-7641 
FAX:            734-930-7611 
E-Mail:         jim.silverman@xxxxxxxxxxx 
                
                From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Joel.Patterson@xxxxxxxxxxx
                Sent: Tuesday, April 10, 2007 10:30 AM
                To: oracle-l@xxxxxxxxxxxxx
                Subject: dbms_scheduler
                
                How do I remove a dbms_scheduler job?   Or see one for
that matter?  I've googled, and got lots of answers, but they seem to
leave off at cleanup.   
                I can see this in all_scheduler_job_log and
all_scheduler_job_run_details as failed as not a valid procedure...
(which is ok).
                DBMON  @ pegrtdev> exec DBMS_SCHEDULER.create_job
('whse_extract', 'STORED_PROCEDURE', 'FactAppointment.Rebuil
                PL/SQL procedure successfully completed.
                DBMON  @ pegrtdev> exec
dbms_scheduler.drop_job('whse_extract', TRUE); BEGIN
dbms_scheduler.drop_job('whse_extract', TRUE); END;
                *
                ERROR at line 1:
                ORA-27475: "DBMON.WHSE_EXTRACT" must be a job
                ORA-06512: at "SYS.DBMS_ISCHED", line 178
                ORA-06512: at "SYS.DBMS_SCHEDULER", line 544
                ORA-06512: at line 1
--
http://www.freelists.org/webpage/oracle-l

Other related posts: