---
title: "Get jobs"
method: GET
path: "/job/list"
tags: ["Jobs"]
---

# Get jobs

`GET /job/list`

Retrieves a list of jobs.

## Response `200`

OK

- object
  - `jobs` Job[], required
    - `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
  - `count` integer, required
  - `from` integer, nullable, required
  - `to` integer, 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)