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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Fixed_date and dbms_job

Re: Fixed_date and dbms_job

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Fri, 14 Mar 2003 10:44:39 -0800
Message-ID: <F001.0056A89F.20030314104439@fatcity.com>


It takes 16 failures to mark the job as "broken".

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

> Ben,
>
> If this problem has not been fixed, check something else.
> Run:
> select job, what, broken, failures from dba_jobs;
>
> I don't know how many, but after a certain number of failures, a job is
marked as broken and won't run automatically.
>
>
> Darrell
>
>
>
> >>> kaderb_at_yahoo.com 03/14/03 08:38AM >>>
> Thanks Jacques,
> Yes I did:
>
> VARIABLE jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(:jobno,
> 'fixed_date_proc.getSystemDate;',sysdate, 'sysdate',
> true);
> commit;
> end;
> /
>
> Ben
>
> --- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
> wrote:
> > After calling dbms_job.submit, did you issue a
> > commit?
> >
> > > -----Original Message-----
> > > From: Kader Ben [mailto:kaderb_at_yahoo.com]
> > >
> > > I'm simulating the date in future with
> > fixed_date.
> > > I wrote procedure to be called every seconde
> > through
> > > dbms_job to increment the fixed_date.
> > >
> > > I did that dbms_job.submit(:job_num,
> > 'myprocedure;',
> > > sysdate, 'sysdate');
> > >
> > > the dba_jobs table show me the right interval un
> > > next_date:
> > >
> > >
> > > BROKEN ST_DATE LAST_SEC NEXT_DATE NEXT_SEC
> > INTERVAL
> > > N 13-JUN-03 00:00:00 13-JUN-03 17:50:06
> > sysdate
> > >
> > > And the sysdate is:
> > > 13-JUN-2003 17:50:06
> > >
> > > But the job never execute.
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - establish your business online
> http://webhosting.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kader Ben
> INET: kaderb_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Darrell Landrum
> INET: DLANDRUM_at_zalecorp.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 14 2003 - 12:44:39 CST

Original text of this message

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