RE: dbms_job - makes my head spin

From: Chiran Ghosh <Chiran.Ghosh_at_AlconLabs.com>
Date: Wed, 27 Sep 2000 08:54:43 -0500
Message-Id: <10632.117990@fatcity.com>

You may want to check the database alert logs for known errors.

-----Original Message-----
From: Rahul [mailto:rahul_at_ratelindo.co.id] Sent: Wednesday, September 27, 2000 8:36 AM To: Multiple recipients of list ORACLE-L Subject: dbms_job - makes my head spin

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_at_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_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 Wed Sep 27 2000 - 08:54:43 CDT