TIME_ELAPSED Function

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
p_job	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;