RE: dbms_scheduler
- From: <jim.silverman@xxxxxxxxxxx>
- To: <Joel.Patterson@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Apr 2007 10:58:23 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
