WHAT Procedure

This procedure changes what an existing job does, and replaces its environment.

Syntax

DBMS_JOB.WHAT ( 
   job       IN  BINARY_INTEGER,
   what      IN  VARCHAR2);

Parameters

Table 19-5 WHAT Procedure Parameters

Parameter	Description
job	Number of the job being run.
what	PL/SQL procedure to run.

Some legal values of what (assuming the routines exist) are:

• 'myproc( ''10-JAN-82'', next_date, broken);'

• 'scott.emppackage.give_raise( ''JENKINS'', 30000.00);'

• 'dbms_job.remove(job);'