Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_scheduler

dbms_scheduler

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 10 Apr 2007 10:29:45 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02CCD8B2@JAX-MBH-01.crowley.com>


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
Received on Tue Apr 10 2007 - 09:29:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US