RE: dbms_scheduler

From: <jim.silverman_at_thomson.com>
Date: Tue, 10 Apr 2007 10:58:23 -0400
Message-ID: <E2157B37A63D2E4B9B00575021FC84D6D8377E@tshusmian2msg01.ERF.THOMSON.COM>

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_at_thomson.com 
		
		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 10: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 - 09:58:23 CDT