RUN_JOB

The RUN_JOB procedure runs a job immediately.

If the job is enabled, the Scheduler automatically runs the job according to its schedule. You do not need to call RUN_JOB to run the job. You call RUN_JOB only to run a job outside its normal schedule.

Syntax

DBMS_SCHEDULER.RUN_JOB (
job_name              IN VARCHAR2,
force                 IN BOOLEAN );

Parameters

Considerations

Before you run a disabled job, the Scheduler performs the following validity checks:

• The job is associated with a valid job class.

• The job owner has the EXECUTE privilege on the job class.

• If the job references a program, the program must exist.

• If the job references a program, the job owner has the EXECUTE privilege on the program.

• All parameter values are set (or have default values).

Examples

Run the MYJOB and SYS.HRJOB jobs immediately.

BEGIN
  DBMS_SCHEDULER.RUN_JOB(
    JOB_NAME            => 'MYJOB, SYS.HRJOB',
    force               => TRUE);
END;