Call this procedure to clean up submitted jobs. Submitted jobs stay in the APEX_PLSQL_JOBS view until either Oracle Application Express cleans out those records, or you call PURGE_PROCESS to manually remove them.
Syntax
APEX_PLSQL_JOB.PURGE_PROCESS (
p_job IN NUMBER);
Parameters
Table 17-2 describes the parameters available in the PURGE_PROCESS procedure.
Table 17-2 PURGE_PROCESS Parameters
| Parameter | Description |
|---|---|
|
|
The job number that identifies the submitted job you want to purge. |
Example
The following example shows how to use the PURGE_PROCESS procedure to purge the submitted job identified by a job number of 161. You could also choose to purge all or some submitted jobs by referencing the APEX_PLSQL_JOBS view.
BEGIN
APEX_PLSQL_JOB.PURGE_PROCESS(
p_job => 161);
END;