9.6.3.2 rqJobStatus Function
Use the rqJobStatus function to look up the status of an asynchronous job. If the job is pending, it returns job is still running . If the job is completed, the function returns a URL.
Syntax
FUNCTION RQSYS.rqJobStatus(
job_id VARCHAR2
)
RETURN RQSYS.rqClobSet
Parameters
| Parameter | Description |
|---|---|
| job_id |
The ID of the asynchronous job. |
Example
The following example shows a rqJobStatus call and its output.
SQL> select * from rqJobStatus(
job_id => '<job id>'
);NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
https://<host_name>/oml/api/r-scripts/v1/jobs/<job_id>/result
1 row selected.
Parent topic: Asynchronous Jobs