Re: HELP: DBMS_JOB QUESTION

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 22 Sep 1999 01:32:43 GMT
Message-ID: <37f52b33.14170628@netnews.worldnet.att.net>

On Tue, 21 Sep 1999 16:41:22 +0900, Huiming Li <huiming_at_jis.ne.jp> wrote:

>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.

I've noticed this type of "drift" in the past myself. I never quite figured out how to solve it--in my case, I could live with it. I remember that I pretty much decided that dbms_job was not going to get you split-second accuracy.

I do recall doing some testing with larger intervals, and seeing the problem dissappear at some point. Unfortunately that was a couple years ago, and I don't remember the details.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Tue Sep 21 1999 - 20:32:43 CDT