Skip to main content

RUN JOB

Description​

Trigger a run for a specified Job.

Note that the SQL statement does not end with ;

Syntax​

RUN JOB <job_name>

Example​

Example command for trigger a Job run.

RUN JOB count_transactions

Required parameters​

  • <job_name>: Name of the Job to run.
    • The Job must already be created.

Status API​

Status API response​

  • API_OPERATION_STATUS_SUCCESS from Status API confirms that the Job has been submitted, but does not reflect its execution status. To monitor the Job's status, send a request to the DESCRIBE JOB_RUN API, and refer to sparkJobRun.status field from its Status API response.
  • API_OPERATION_STATUS_FAILED from Status API does not necessarily mean the Job was not submitted. To confirm whether the Job was submitted, send a request to the DESCRIBE JOB API, and refer to sparkJobRun.latestJobStatus and sparkJobRun.latestJobRunSubmittedAt fields from its Status API response.

Example Status API response​

The Status API response of a successful Job submission.

{
    "apiStatus": "API_OPERATION_STATUS_SUCCESS",
    "apiResponse": {
        "runJobApiResponse": {
            "jobRunId": "<job_run_id>"
        }
    }
}