Comment on page
This command drops the specified job.
SQL syntax to drop a job in Upsolver.
DROP JOB [ IF EXISTS ] <job_name>;
(Optional) To prevent the Upsolver query engine from returning an error if the job does not exist, include
IF EXISTSin your
DROPstatement; instead, you will see the message Operation resulted in no change.
You cannot delete individual sub-jobs, instead, you use the
DROP JOBcommand to drop the master job and all sub-jobs.
The following example runs a
IF EXISTSto drop the job, ingest_sales_data. By including
IF EXISTS, an error is not encountered if the job does not exist. Otherwise, if the job exists, it will be dropped from the organization:
DROP JOB IF EXISTS "ingest_sales_data";