Basically you want to set your interval to

SYSDATE + 2 / 24

This will set the next_date to two hours after the time the job starts.
Note that the time is NOT exact, the init.ora parameter
JOB_QUEUE_INTERVAL sets the frequency that the job queue is
checked and the job will start slightly later than you specify.

To correct this drift, try an interval of
TRUNC(SYSDATE,'HH24') + 2 / 24

Hope This Helps

Garry Gillies




"Edwin Uy "
<oracledba-ezmlms
hield-x84400610.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
10/07/2004 13:20
Subject
DBMS_JOB










Hi all,

Anyone with an example of using DBMS_JOB? I want to be able to run a
task that runs every two hours during the day.

Cheers,


EDWIN ONG UY




CONFIDENTIAL:

The information contained in this email (including any attachments)
is confidential, subject to copyright and for the use of the
intended recipient only. If you are not the intended recipient
please delete this message after notifying the sender. Unauthorised
retention, alteration or distribution of this email is forbidden
and may be actionable.

Attachments are opened at your own risk and you are advised to scan
incoming email for viruses before opening any attached files. We
give no guarantee that any communication is virus-free and accept
no responsibility for virus contamination or other system loss or
damage of any kind.

Oracle LazyDBA home page