WHAT v16

The WHAT procedure changes the stored procedure that the job executes.

WHAT(<job> BINARY_INTEGER, <what> VARCHAR2)

Parameters

job

Identifier of the job whose stored procedure you want to change.

what

Name of the stored procedure to execute.

Change the job to run the list_emp procedure:

BEGIN
    DBMS_JOB.WHAT(104,'list_emp;');
END;

SUBMIT

DBMS_LOB