Skip to main content

DELETE JOB

Description​

Delete a specified Job.

info

Deleting a Job will remove it from the Onehouse console and prevent users from triggering new runs for the Job. Job runs already queued will not be canceled when you delete the Job.

Note that the SQL statement does not end with ;

Syntax​

DELETE JOB <job_name>

Examples​

DELETE JOB count_transactions

Required parameters​

  • <job_name>: Specify the name of the Job to delete.

Status API​

Status API response​

  • API_OPERATION_STATUS_SUCCESS from Status API indicates that the Job has been deleted.
  • API_OPERATION_STATUS_FAILED from Status API does not necessarily mean the Job has been deleted. To confirm whether the Job is deleted, send a request to the DESCRIBE JOB API and confirm its API status is API_OPERATION_STATUS_FAILED with errorResponse value of NOT_FOUND: Job not found: <job_name>.

Example Status API response​

The status API response of successful deletion of a Job.

{
    "apiStatus": "API_OPERATION_STATUS_SUCCESS",
    "apiResponse": {}
}