Skip to main content

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 to cancel it.

Syntax

SHOW JOBS [ LIKE_expression ];

Parameters

ParameterDescription
LIKE_expressionFilters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions.

Example

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%

Help us make this doc better!