SET_KEEP_BACKGROUND_EXECS Procedure

6.37 SET_KEEP_BACKGROUND_EXECS Procedure

This procedure preserves background executions associated with the application during upgrades.

Syntax

APEX_APPLICATION_INSTALL.SET_KEEP_BACKGROUND_EXECS (
    p_keep_background_execs IN BOOLEAN );

Parameters

Table 6-6 SET_KEEP_BACKGROUND_EXECS Parameters

Parameter	Description
`p_keep_background_execs`	`TRUE` to preserve background executions, `FALSE` to delete them.

Example

The following example installs application 100 in workspace FRED_PROD and preserves background executions.

BEGIN
   apex_application_install.set_workspace(p_workspace => 'FRED_PROD');
   apex_application_install.set_keep_background_execs(p_keep_background_execs => true);
END;
/
@f100.sql