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

Home -> Community -> Usenet -> c.d.o.tools -> Re: using dbms_job

Re: using dbms_job

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: 2000/06/27
Message-ID: <8jau9q$7642$1@ID-13717.news.cis.dfn.de>#1/1

peter ball wrote
> In user_jobs table I have two broken jobs, job_number 21 and 22
> How can I run them?

BEGIN
  DBMS_JOB.BROKEN(21,FALSE);
  DBMS_JOB.BROKEN(21,FALSE);
  COMMIT;
END; Hth,
Uli Received on Tue Jun 27 2000 - 00:00:00 CDT

Original text of this message

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