12.7.3 Asynchronous Jobs (Autonomous Database)

When a function is run asynchronously, it's run as a job which can be tracked by using the pyqJobStatus and pyqJobResult functions.

Topics:

• oml_async_flag Argument

• pyqJobStatus Function

• pyqJobResult Function

• Asynchronous Job Example

• oml_async_flag Argument
  The special control argument oml_async_flag determines if a job is run synchronously or asynchronously. The default value is false.
• 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.
• pyqJobResult Function
  Use the pyqJobResult function to return the job result.
• Asynchronous Job Example
  The following examples shows how to submit asynchronous jobs with non-XML output and with XML output.