Re: dbms_job.run

From: Glenn Folue <nospam_at_nospam.com>
Date: Tue, 18 Feb 2003 19:35:27 GMT
Message-ID: <3Wv4a.168902$Ec4.169708@rwcrnsc52.ops.asp.att.net>

I don't think you can call dbms_job.run from a job (or maybe I'm thinking about .submit). Try using

DBMS_JOB.BROKEN(job_num, FALSE, sysdate);

This changes job so that it is not longer broken and runs it immediately.

--
Best of Breed Oracle Tools

* ER Diagramming Tool - DBArtisan
by http://www.embarcadero.com

* PL/SQL Editor - SQL Navigator
by http://www.quest.com

* Database Monitoring - DBFlash for Oracle
by http://www.confio.com

* SQL Tuning/Optimization - DB Expert
by http://www.leccotech.com

"Imran Rahim" <i_rahim_at_hotmail.com> wrote in message
news:e7519cfe.0302171610.16997f6f_at_posting.google.com...


> I want to have a scheduled job on dba_jobs that runs periodically and

> performs a dbms_job.run(jobnum) on any job that is broken in the

> queue. It is failing with an obscure ora 600 error. Is there any way

> to do this?

Received on Tue Feb 18 2003 - 13:35:27 CST