RE: dbms_scheduler

From: Pabba, Chandra <Chandra.Pabba_at_fmr.com>
Date: Tue, 10 Apr 2007 10:01:09 -0500
Message-ID: <6D2375ACD32D9B48A9B433AA0527B0840640FA43@MSGDCCCLA2WIN.DMN1.FMR.COM>

Joel,  

I tried the following and it worked.  

SQL> exec
dbms_scheduler.create_job(job_name=>'TEST',job_type=>'STORED_PROCEDURE', job_action=>'load_data');  

PL/SQL procedure successfully completed.  

SQL> exec dbms_scheduler.drop_job(job_name=>'TEST',force=>TRUE);  

PL/SQL procedure successfully completed.  

SQL> But, when I created a job with job_name and job_action being the same name and when attempted to drop, it did fail with the same set of errors:  

exec
dbms_scheduler.create_job(job_name=>'load_data',job_type=>'STORED_PROCED URE',job_action=>'load_data');

SQL> exec dbms_scheduler.drop_job(job_name=>'load_data',force=>TRUE); BEGIN dbms_scheduler.drop_job(job_name=>'load_data',force=>TRUE); END;  

*
ERROR at line 1:

ORA-27475: "TEST.LOAD_DATA" 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
 

SQL>   Thanks
Chandra Pabba
972-584-2289  

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com

	Sent: Tuesday, April 10, 2007 9:30 AM
	To: oracle-l_at_freelists.org
	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

Received on Tue Apr 10 2007 - 10:01:09 CDT