Oracle-L: RE: Fixed_date and dbms

From: Darrell Landrum <DLANDRUM_at_zalecorp.com>
Date: Fri, 14 Mar 2003 08:24:34 -0800
Message-ID: <F001.0056A38C.20030314082434@fatcity.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).

Received on Fri Mar 14 2003 - 10:24:34 CST

RE: Fixed_date and dbms_job