> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW JOBS

> Use `SHOW JOBS` to get all streaming jobs that are in progress, including their IDs, the specific statements, and their progresses.

In RisingWave, a streaming job refers to the creation of a materialized view, an index, a table, a sink or a source with connectors. If a streaming job takes too long, you can use the [CANCEL JOBS](/sql/commands/sql-cancel-jobs) to cancel it.

## Syntax

```sql theme={null}
SHOW JOBS [ LIKE_expression ];
```

## Parameters

| Parameter        | Description                                                                                                                                                                  |
| :--------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| LIKE\_expression | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions). |

## Example

```sql theme={null}
SHOW JOBS;
------RESULT
  Id  |                     Statement                     | Progress
------+---------------------------------------------------+----------
 1010 | CREATE MATERIALIZED VIEW mv3 AS SELECT *FROM mv1  | 2.21%
 1012 | CREATE MATERIALIZED VIEW mv2 AS SELECT* FROM mv1  | 0.86%
```

## Related topics

<CardGroup>
  <Card title="Monitor statement progress" icon="chart-line" iconType="solid" href="/operate/monitor-statement-progress" />

  <Card title="CANCEL JOBS" icon="circle-stop" iconType="solid" href="/sql/commands/sql-cancel-jobs" />
</CardGroup>