Re: HELP: DBMS_JOB QUESTION

From: Huiming Li <huiming_at_jis.ne.jp>
Date: Wed, 22 Sep 1999 11:50:02 +0900
Message-ID: <37E843DA.4A6E27D7@jis.ne.jp>

I think that it's the time to close this thread. Everybody, Thanks. I really appreciate it.

As described in Mr. Christopher Beck's message, I changed the submit command as follows:

dbms_job.submit(:jobno, 'TEST_JOB;', to_date('19990922111500', 'YYYYMMDDHH24MISS'), 'trunc(sysdate, ''HH24'') + (trunc(to_char(sysdate, ''MI'')/15)*15+15)/1440');

Now it works. The job will be executed once about 15min. and the drift will not getting larger and larger any more. No drift accumulation any more. (This is what I expected.).

Thanks once more.

Huiming Li Received on Tue Sep 21 1999 - 21:50:02 CDT