Is It Possible To Assign Chain Parameters To A Scheduler Job? (Doc ID 1272728.1)

Last updated on DECEMBER 20, 2019

Applies to:

Goal

Question:
Is it possible that chain parameters can be inherited to a job ?

Answer:
It is not possible that a chain set values which the job will inherit.
The only way is using metadata with using DEFINE_METADATA_ARGUMENT Procedure.
This procedure defines a special metadata argument for the program. The Scheduler can pass Scheduler
metadata through this argument to your stored procedure or other executable. You cannot set values for jobs
using this argument.

Syntax

The 'metadata_attribute' is the metadata to be passed.
Valid Metadata Attributes are: 'job_name', 'job_subname', 'job_owner', 'job_start',
'window_start', 'window_end', and 'event_message'.

The  Metadata Attribute 'job_subname' is the subname of the currently running job.
The name + subname form a unique identifier for a job that is running a chain step.
NULL if the job is not part of a chain.

For more information about Metadata Attributes, see  the documentation:

Oracle� Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)
Part Number B14258-02


For chains, the steps must point to programs and can't have arguments.
So create a program which has a single metadata argument. 
Use the 'job_subname', then you can point a step to that program.
The scheduler will automatically set the value of this argument to the stepname and
your stored procedure can then use the stepname to do whatever it wants.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.