Message-Id: <10632.118019@fatcity.com> From: "Thapliyal, Deepak" Date: Wed, 27 Sep 2000 09:36:31 -0700 Subject: RE: dbms_job - makes my head spin can u post that "simple proc" -----Original Message----- From: Joan Hsieh [mailto:jhsieh@infonet.tufts.edu] Sent: Wednesday, September 27, 2000 8:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: dbms_job - makes my head spin You may check if the job is broken or not. select what, job from user_jobs; get job# from this query, then select broken,interval,failures from user_jobs where job=; If B=Y, you have to rerun the job ==> maybe execute dbms_job.run(job#)? Joan Chiran Ghosh wrote: > > You may want to check the database alert logs for known errors. > > -----Original Message----- > Sent: Wednesday, September 27, 2000 8:36 AM > To: Multiple recipients of list ORACLE-L > > List, > 8.1.5 (AIX) > job_queue_processes = 1 > job_queue_interval = 10 > > snp process is running , i checked.. > > i have a simple stored procedure (tmp)which inserts a number into a table > which i submitted as a job.. > > dbms_job.submit(job_no,'tmp;',sysdate,'sysdate(1/1440'); > dbms_job.run(job_no); > > the interval is sysdate+1/1440 which calculates to 1 min. > > after i submit the job it runs once - baecuase of the dbms_job.run, but then > fails to run at the 1 min. interval !!! the NEXT_TIME column IS updated > every minute > to reflect the new next_time but the FAILURES increase each time. > > what am i missing here...?? > > Thanks > Rahul > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > INET: rahul@ratelindo.co.id > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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.com > -- > Author: Chiran Ghosh > INET: Chiran.Ghosh@AlconLabs.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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.com -- Author: Joan Hsieh INET: jhsieh@infonet.tufts.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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