Use this function to determine how much time has elapsed since the job was submitted.
Syntax
APEX_PLSQL_JOB.TIME_ELAPSED( p_job IN NUMBER) RETURN NUMBER;
Parameters
Table 17-4 describes the parameters available in the TIME_ELAPSED
function.
Table 17-4 TIME_ELAPSED Parameters
Parameter | Description |
---|---|
|
The job ID for the job for which you want to determine the time that has passed since it was submitted. |
Example
The following example shows how to use the TIME_ELAPSED
function to get the time elapsed for the submitted job identified by the job number 161.
DECLARE l_time NUMBER; BEGIN l_time := APEX_PLSQL_JOB.TIME_ELAPSED(p_job => 161); END;