# Get execution history

Gets a history of scheduled executions by name.

Endpoint: GET /schedule/history/{schedule_name}
Version: 3
Security: ApiKeyAuth

## Path parameters:

  - `schedule_name` (string, required)

## Query parameters:

  - `from` (integer)

  - `to` (integer)

## Response 200 fields (application/json):

  - `count` (integer, required)
    Example: 20

  - `from` (integer, required)
    Example: 5

  - `to` (integer, required)
    Example: 15

  - `history` (array, required)

  - `history.cpu_time` (integer,null, required)

  - `history.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)
    Example: "2020-12-31 11:22:33 UTC"

  - `history.database` (string,null, required)
    database name

  - `history.duration` (integer,null, required)
    Duration
    Example: 10

  - `history.end_at` (any, required)

  - `history.hive_result_schema` (string,null, required)
    the schema for the job's result table

  - `history.job_id` (string, required)
    unique identifier of job
    Example: "19"

  - `history.linked_result_export_job_id` (any, required)

  - `history.num_records` (integer,null, required)
    the number of records in the result. Will be null until job has finished, and may not be set for all query types
    Example: 100

  - `history.priority` (integer, required)
    job execution priority

  - `history.query` (any, required)
    - `in` (object)
    - `in.connection_prop` (string)
      Example: "connection_prop"
    - `in.connection_secret` (string)
      Example: "secret"
    - `in.basic_prop` (string)
      Example: "basic"
    - `in.basic_secret` (string)
      Example: "secret"
    - `in.advanced_prop` (string)
      Example: "advanced"
    - `in.advanced_secret` (string)
      Example: "secret"
    - `in.type` (string)
      Example: "some_type"
    - `in.td_authentication_id` (integer)
      Example: 1234
    - `filters` (array)
    - `exec` (object)
    - `exec.type` (string)
      Example: "some_type"
    - `exec.basic_prop` (string)
      Example: "basic"
    - `exec.secret_prop` (string)
      Example: "secret"
    - `out` (object)
    - `out.type` (string)
      Example: "some_type"
    - `out.mode` (string)
      Example: "mode"
    - `out.plazma_dataset` (string)
      Example: "plazma"
    - `out.time_column` (string)
      Example: "time"

  - `history.result` (string)
    URL of the result output destination

  - `history.result_export_target_job_id` (any, required)

  - `history.result_size` (integer,null, required)
    size in bytes of the job's result, in msgpack.gz format
    Example: 1048576

  - `history.retry_limit` (integer, required)
    automatically retry this many times on failure
    Example: 3

  - `history.start_at` (any, required)

  - `history.status` (string, required)
    current status of the job
    Enum: "queued", "running", "killed", "success", "error"

  - `history.type` (string, required)
    Example: "presto"

  - `history.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)
    Example: "2020-12-31 11:22:33 UTC"

  - `history.url` (string, required)

  - `history.user_name` (string, required)
    user's full name or email
    Example: "Treasure Data"

  - `history.scheduled_at` (any, required)

  - `history.organization` (string,null, required)
    always "null"