Thanks!! Darrell Landrum Database Administrator Zale Corporation
>>> [EMAIL PROTECTED] 03/14/03 12:44PM >>> It takes 16 failures to mark the job as "broken". Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 11:24 AM > 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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman 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).