Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Tue Apr 10 2007 - 09:29:45 CDT
![]() |
![]() |