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%

Monitor statement progress

CANCEL JOBS