13.7.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://<oml-cloud-service-location-url>/oml/api/py-scripts/v1/jobs/<job id>/result

1 row selected.

Parent topic: Asynchronous Jobs (Autonomous Database)