DROP JOB
This command drops the specified job.
Syntax
SQL syntax to drop a job in Upsolver.
IF EXISTS
IF EXISTS (Optional) To prevent the Upsolver query engine from returning an error if the job does not exist, include IF EXISTS in your DROP statement; instead, you will see the message Operation resulted in no change.
Dropping a replication job that has sub-jobs
When you create a replication job, a sub-job is created to replicate the data, and a sub-job is created for each replication group. This is also applicable if you created a parent script to generate sub-jobs to replicate your data.
You cannot delete individual sub-jobs, instead, you use the DROP JOB command to drop the master job and all sub-jobs.
Example
The following example runs a DROP statement with IF EXISTS to 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 a job using the UI
You can also drop a job from the Jobs page in the UI. Hover over the three-dots menu on the job you want to drop, and select Drop Job:
You will then be presented with a modal window asking you to confirm if you want to drop the job and all associated metadata and logs. The modal window also presents you with the SQL syntax for dropping the job, should you wish to copy and paste this into a worksheet to run the statement manually.
Click Drop Job to continue, and the job status will refresh and display Deleting. Alternatively, click Cancel to exit without dropping the job.
Last updated
