CONFIRM THAT THE JOB WAS LAUNCHED

8. Confirm that the job was launched:

select actual_start_date,status from dba_scheduler_job_run_detailswhere job_name='LOAD_DATA';

This very simple example is intended to illustrate a mechanism whereby the arrival

of a file could trigger the running of a job. The code in Step 7 would be executed by

the process that generates, or detects, the file: it enqueues a message with the value

of the payload’s single attribute set to 1. This value will be checked by the Scheduler,

which will then run the LOAD_DATA job.

Job Chains

A chain represents a set of linked programs with execution dependencies. The steps to

follow to use job chains are