---
title: "List jobs"
method: GET
path: "/v3/sql/jobs"
tags: ["SQL"]
---

# List jobs

`GET /v3/sql/jobs`

Lists the asynchronous jobs in your account.

Only `userId`, `createdSince` and `client` are accepted — any other query
parameter returns `400`.

## Query parameters

- `user_id` string
- `created_since` string, date-time

## Response `200`

The jobs.

- JobListItem[]
  - `externalId` string
  - `accountId` string
  - `userId` string, nullable
  - `connectionId` string
  - `metadata` object
  - `createdAt` string, date-time
  - `updatedAt` string, date-time
  - `query` string, nullable
  - `state` 'pending' | 'running' | 'success' | 'failure' | 'cancelled' | 'blocked' | 'resuming_warehouse' — `success`, `failure` and `cancelled` are final states.
  - `jobMetadata` object
  - `token` string, nullable

## Other responses

- `400` — The request is malformed or a parameter failed validation.
- `401` — The token is missing, malformed or expired.
- `403` — The token doesn't grant access to this resource.
- `429` — You went over the [rate limit](#rate-limits) for this API.

---

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