You can see all existing pipelines in a database and their current state by using the SHOW PIPELINES statement.

Possible states are Running, Testing, Profiling, Running...Foreground, Stopped, and Error, and they are described in the Pipelines Information Schema Tables topic.

Background pipelines will show True in the Scheduled column until the task is finished. Background pipelines could show False if the pipeline is in an error state or during a batch interval period while waiting for data. It can also show False if there’s a delay starting the pipeline due to system load, etc.

Non-background pipelines will always show False in the Scheduled column.

SHOW PIPELINES

SHOW PIPELINES;

+------------------------+---------+-----------+
| Pipelines_exp_db       | State   | Scheduled |
+------------------------+---------+-----------+
| color_list             | Running | True      |
| color_list2            | Running | False     |
+------------------------+---------+-----------+