SET_JOB_ARGUMENT_VALUE v17

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 the argument to modify 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 the 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 is set.

argument_name

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

argument_value

argument_value specifies the new value of the argument.

Examples

This 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');

This example sets the emp_name argument to SMITH:

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