The WHAT procedure changes the SQL statement run by a specified job.
NAME TASKID
--------------- ------
DBMS_JOB_TASK_2 3
DBMS_JOB_TASK_3 4
If you want to modify DBMS_JOB_TASK_2,
you must pass 2 as the job identifier.EXECUTE privilege on the DBMS_JOB module.
CALL DBMS_JOB.WHAT(104,'list_emp;');