You can delete a specific job using its unique job ID by using the pyqDeleteJob() function.

Syntax

FUNCTION pyqDeleteJob(
   job_id  VARCHAR2
) 

Returns these columns: NAME(Status message such as example "job deleted successfully"), VALUE (Additional value (typically empty on success)).

Parameters

job_id: Job ID of the job that you are trying to delete.

Example

The following example shows a pyqDeleteJob call and its output.

SELECT * FROM pyqDeleteJob('<job_id>');

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
job deleted successfully

1 row selected.