Skip to main content

SHOW RUNS IN JOB

Description​

Lists all runs for the specified Job.

Note that the SQL statement does not end with ;

Syntax​

SHOW RUNS IN JOB <job_name>

Example​

SHOW RUNS IN JOB my_job

Status API​

Example Status API response​

The Status API response of listing runs in the Job.

{
    "apiStatus": "API_OPERATION_STATUS_SUCCESS",
    "apiResponse": {
        "showRunsInJobApiResponse": {
            "sparkJobRun": [
                <sparkJobRun1>,
                <sparkJobRun2>,
                <sparkJobRun3>,
                ...
            ]
        }
    }
}

<sparkJobRun> objects in the example response above are the same as sparkJobRun in the Status API response of the DESCRIBE JOB_RUN API.