SET_JOB_ARGUMENT_VALUE v11

Suggest edits

Use the SET_JOB_ARGUMENT_VALUE procedure to specify a value for an argument. The SET_JOB_ARGUMENT_VALUE procedure comes in two forms; the first form specifies which argument should be modified by position:

SET_JOB_ARGUMENT_VALUE(
  <job_name> IN VARCHAR2,
  <argument_position> IN PLS_INTEGER,
  <argument_value> IN VARCHAR2)

The second form uses an argument name to specify which argument to modify:

SET_JOB_ARGUMENT_VALUE(
  <job_name> IN VARCHAR2,
  <argument_name> IN VARCHAR2,
  <argument_value> IN VARCHAR2)

Argument values set by the SET_JOB_ARGUMENT_VALUE procedure override any values set by default.

Parameters

job_name

job_name specifies the name of the job to which the modified argument belongs.

argument_position

Use argument_position to specify the argument position for which the value will be set.

argument_name

Use argument_name to specify the argument by name for which the value will be set.

argument_value

argument_value specifies the new value of the argument.

Examples

The following example assigns a value of 30 to the first argument in the update_emp job:

DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('update_emp', 1, '30');

The following example sets the emp_name argument to SMITH:

DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('update_emp', 'emp_name', 'SMITH');
← Prev

RUN_JOB

Next →

DBMS_SESSION