---
title: "List Jobs"
method: GET
path: "/job/list"
tags: ["Job"]
---

# List Jobs

`GET /job/list`

Administrators, impersonating a service user, can request a list of jobs for a sub-account.

## Response `200`

OK

- JobListResult
  - `jobs` JobInfo[], nullable
    - `jobType` string, required — The type of job (Caching).
    - `id` string, required — The job's Id.
    - `name` string, required — The job's name.
    - `enabled` boolean, required — A Boolean value indicating whether the job is enabled.
    - `created` string, date-time, required — The date and time the job was created.
    - `lastModified` string, date-time, required — The date and time the job was last modified.
    - `nextRunTime` string, date-time, required — The date and time the job is scheduled to be run next.
    - `intervalUnit` string, required — A string representing the interval unit for the job (Hour/Day/Week/Month).
    - `intervalValue` integer, required — An integer that represents how many of the selected interval unit the job should wait before running again.
    - `logVerbosity` integer, required — A number indicating the level of log verbosity (1-5).
    - `lastRun` JobLastRun — The last run metrics for the job, including the date and time, duration, status, rows affected, and next run time.
      - `dateTime` string, date-time, nullable
      - `duration` integer, nullable
      - `status` string, nullable
      - `rowsAffected` integer, nullable
      - `nextRunTime` string, date-time, nullable — The date and time the job is scheduled to be run next.
    - `params` JobParams — An object containing job parameters. Caching jobs use the fields below; other job types may include additional properties.
      - `sourceConnection` string, uuid — The Id of the source connection.
      - `sourceConnectionName` string — The name of the source connection. Returned in responses.
      - `sourceName` string — The source driver name (for example, "Asana", "MailChimp").
      - `sourceSchema` string — The schema in the source connection that contains the table being cached.
      - `sourceTable` string — The name of the table in the source connection to cache.
      - `timeCheckColumn` string — The column used to detect changes for incremental caching. Leave empty to refresh the full table.
      - `autoTruncateStrings` string — Whether to truncate string values that exceed the destination column length. Accepted as a string by the API ("true" or "false").
      - `mergeKeys` MergeKey[] — The columns used to match source rows against cached rows during a merge. Mark each column that is part of the primary key with `isPrimaryKey: true`; supplying more than one such entry defines a composite primary key.
        - `colName` string — The name of the column.
        - `colType` string — The column's data type (for example, "varchar").
        - `isPrimaryKey` boolean — Whether the column is part of the primary key. Set `true` on multiple columns to define a composite primary key.

---

[API](https://skmtc.dev/cdata/apis/cdata-connect-ai-rest-api-embedded.md) · [All operations](https://skmtc.dev/cdata/apis/cdata-connect-ai-rest-api-embedded/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/cdata/cdata-connect-ai-rest-api-embedded/revisions/c13133ad66c0/schema)