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 >>> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: > After calling dbms_job.submit, did you issue a > commit? > > > -----Original Message----- > > From: Kader Ben [mailto:[EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).