10.6.3.2 pyqJobStatus Function

Use the pyqJobStatus 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 PYQSYS.pyqJobStatus(
  job_id       VARCHAR2 
)
RETURN PYQSYS.pyqClobSet

Parameters

Parameter	Description
job_id	The ID of the asynchronous job.

Example

The following example shows a pyqJobStatus call and its output.

SQL> select * from pyqJobStatus(
       job_id => '<job id>'
);

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------

https://<host name>/oml/tenants/<tenant name>/databases/<database name>/api/py-scripts/v1/jobs/<job id>/result


1 row selected.