Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_job - makes my head spin
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
![]() |
![]() |