In Oracle, the DBMS_SCHEDULER.SET_ATTRIBUTE procedure modifies attributes of a program associated with a scheduler job. The program_name parameter specifies the name of the program to be modified.
The program_name parameter represents the name of the program associated with a scheduler object or job. When passed to the DBMS_SCHEDULER.SET_ATTRIBUTE procedure it identifies the specific program that’s being modified.
The program_type parameter specifies the type of program being modified. This can be a stored procedure, executable, or external shell script. Program_action defines the action for the program.
Define_program_argument defines arguments for a program. Arguments can be passed to a program to provide dynamic values or inputs during execution.
Number_of_arguments is the number of arguments defined for a program. The program_name procedure is used in conjunction with this parameter to define and manage program arguments.
There is predefined metadata arguments that can be passed to programs if program logic is dependent on the scheduler environment.
Redwood integrates easily with ERP systems to orchestrate and automate Oracle workflows.