How To Use A Dynamic Argument in DBMS_SCHEDULER (Doc ID 2871136.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Need to have a way to use a dynamic argument (e.g. SYSDATE) for a JOB program.
However, the DBMS_SCHEDULER.SET_JOB_ANYDATA_VALUE procedure does not dynamically change the argument value.
It always uses fixed value, regardless of when the job is run.
How can I use a dynamic value in the JOB?

Solution

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