Oracledbms_job Oracle10g dbms_scheduler what next_date dbms

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Overview and Examples of dbms_job Functions

BEGIN
DBMS_JOB.what (
    job => 99,
    what => 'my_job_proc(''DBMS_JOB.ISUBMIT Example (WHAT).'');');

DBMS_JOB.next_date (
    job       => 99,
    next_date => SYSDATE + 1/12);

DBMS_JOB.interval (
    job      => 99,
    interval => 'SYSDATE + 1/12 /* 2 Hours */');

COMMIT;

END;
/

The output generated by the user_jobs.sql shows that the changes have been applied.

SQL> @jobs job_user

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm