---
title: "Get job"
method: GET
path: "/job/show/{job_id}"
tags: ["Jobs"]
---

# Get job

`GET /job/show/{job_id}`

Retrieves a list of jobs with specified job id.

## Path parameters

- `job_id` integer, required — unique identifier of job

## Response `200`

OK

- object — an execution of a query
  - `cpu_time` integer, nullable, required
  - `created_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
  - `database` string, nullable, required — database name
  - `duration` integer, nullable, required — Duration
  - `end_at` union, required
    - string — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
    - string
  - `hive_result_schema` string, nullable, required — the schema for the job's result table
  - `job_id` string, required — unique identifier of job
  - `linked_result_export_job_id` union, required
    - integer — unique identifier of job
    - integer, nullable — result job id
  - `num_records` integer, nullable, required — the number of records in the result. Will be `null` until job has finished, and may not be set for all query types
  - `organization` string, nullable, required — always "null"
  - `priority` integer, required — job execution priority
  - `query` union, required
    - string, nullable
    - string — the raw SQL query
    - BulkLoadConfig — bulk load config
      - `in` object
        - `connection_prop` string
        - `connection_secret` string
        - `basic_prop` string
        - `basic_secret` string
        - `advanced_prop` string
        - `advanced_secret` string
        - `type` string
        - `td_authentication_id` integer
      - `filters` object[]
      - `exec` object
        - `type` string
        - `basic_prop` string
        - `secret_prop` string
      - `out` object
        - `type` string
        - `mode` string
        - `plazma_dataset` string
        - `time_column` string
  - `result` string — URL of the result output destination
  - `result_export_target_job_id` union, required
    - integer — unique identifier of job
    - integer, nullable — result export job id
  - `result_size` integer, nullable, required — size in bytes of the job's result, in `msgpack.gz` format
  - `retry_limit` integer, required — automatically retry this many times on failure
  - `start_at` union, required
    - string — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
    - string
  - `status` 'queued' | 'running' | 'killed' | 'success' | 'error', required — current status of the job
  - `type` string, required
  - `updated_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
  - `url` string, required
  - `user_name` Name, required — unresolved $ref
  - `debug` object, required
    - `cmdout` string, nullable, required
    - `stderr` string, nullable, required

---

[API](https://skmtc.net/treasure/apis/treasure-data-api.md) · [All operations](https://skmtc.net/treasure/apis/treasure-data-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/treasure/treasure-data-api/revisions/a753ea35d9dd/schema)