Oracledbms_job Oracle10g dbms_scheduler test environment dbms_system dbms_application dbms

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Setting up a Test Environment

      op_name     => 'MY_JOB_PROC',
      target      => l_obj,
      context     => 0,
      sofar       => i,
      totalwork   => l_total,
      target_desc => 'MY_JOB_PROC',
      units       => 'loops');

    DBMS_LOCK.sleep(1);
END LOOP;

DBMS_APPLICATION_INFO.set_action(
    action_name => p_text || ': End.');

SYS.DBMS_SYSTEM.ksdwrt(2, 'MY_JOB_PROC End: ' || p_text);
END;

/
SHOW ERRORS

The procedure can be tested by calling it from SQL*Plus as follows:

SQL> exec my_job_proc('Test It!');

Once the procedure has completed, the alert log should contain an entry that looks similar to the following:

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