9.6.2.8 rqDeleteJob Function

Use the rqDeleteJob function to delete a job.

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

Syntax

FUNCTION rqDeleteJob(
   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 rqDeleteJob call and its output.

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

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

1 row selected.