MODIFY_APP_ACT_JEXEC

Modify an action which executes an external scheduler job

Parameter Name

Required

Description

p_app_name

yes

Name of the application

p_action_name

yes

Name of the action

p_description

no

Description of the action

p_finished_type

yes

Status triggering the action (LOADED, PRELIM, FINAL)

p_jexec_call

yes

JEXEC call parameter

p_jexec_par1

no

Optional Parameter 1 for JEXEC call

p_jexec_par2

no

Optional Parameter 2 for JEXEC call

p_valid_from_bdate

yes

Action’s initial execution date

p_active

yes

Action execution condition (true/false)

p_run_once

yes

Execute action only once per day? (true/false)

p_run_delay

yes

Delay time after condition met (seconds)

p_bdate_retention

yes

Trigger period for application actions in number of days

Example

EXECUTE SCRIPT api_redadm.modify_app_act_jexec
            ( 'XXX'         -- p_app_name
            , 'XXX'         -- p_action_name
            , 'XXX'         -- p_description
            , 'LOADED'      -- p_finished_type
            , 'XXX'         -- p_jexec_call
            , 'XXX'         -- p_jexec_par1
            , 'XXX'         -- p_jexec_par2
            , '2025-01-01'  -- p_valid_from_bdate
            , TRUE          -- p_active
            , TRUE          -- p_run_once
            , 60            -- p_run_delay
            , 10            -- p_bdate_retention
            );