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;