HELP: DBMS_JOB QUESTION

From: Huiming Li <huiming_at_jis.ne.jp>
Date: Tue, 21 Sep 1999 16:41:22 +0900
Message-ID: <37E736A2.115ABB9E@jis.ne.jp>

Hi, everybody,

I expect my job to execute automatically every 15 minutes (exactly!). Is there a way?

The following is what I have done and the result.

Initialization parameters:
job_queue_processes = 1
job_queue_interval = 60

execute dbms_job.submit(:jobno, 'XYZ;', SYSDATE, 'SYSDATE + 1/96');

what I got:

 The 1st Time 15:40:13 (expected time 15:40:00)
 The 2nd Time 15:55:40 (expected time 15:55:00)
 The 2nd Time 16:11:20 (expected time 16:10:00)

....

It seems that the error is getting larger and larger.

Thanks in advance. Received on Tue Sep 21 1999 - 02:41:22 CDT