# SHOW JOBS

Returns information on the job(s) with the specified ID(s).

## Syntax

```
SHOW JOBS '<job_ID>', ... 
    [ EXTENDED ]
    [ LIKE '<pattern>' 
```

## Arguments

* `job_ID`: A comma-separated list of job ID(s).
* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause and returns jobs with names that match the specified pattern. Uses `%` as the wildcard character.

  **Note**: The `LIKE` clause filters by job names, not job IDs.

## Remarks

* Specify `EXTENDED` to return more information on the specified job(s).

## Example

The following command shows extended information on the job with ID `058e2ed1-3000-4000-a000-512d334df903`:

```sql
SHOW JOBS '058e2ed1-3000-4000-a000-512d334df903' EXTENDED;

```

```output

JobID					Name	        CreatedAt			EnqueuedBy				CompletedExecutions	NotebookPath			DatabaseName	TargetID    TargetType      Description		TerminatedAt	CreateSnapshot	MaxDurationInMins    ExecutionIntervalInMins	Mode	StartAt			ResumeTarget
058e2ed1-3000-4000-a000-512d334df903	jobExample	2025-08-28 12:24:10.864610	609e4c83-6000-4000-8000-24ab62c2097c	0			Basic Query Examples .ipynb	None		None	    None            Sample test Job	None		0        	120		     None	                Once	2025-09-26 11:30:00	None
```

***

Modified at: September 12, 2025

Source: [/cloud/reference/fusion-sql/show-jobs/](https://docs.singlestore.com/cloud/reference/fusion-sql/show-jobs/)

(An index of the documentation is available at /llms.txt)