SHOW JOBS lists all stream jobs in the current resource group. Use it to check job status after submitting a stream job, or to retrieve a Query ID for use in other job management statements.
Requirements
SHOW JOBS requires a stream engine at version 3.1.8 or later. To check your engine version or update to a supported version, see Upgrade the minor engine version.
Syntax
SHOW JOBSExample
List all stream jobs in the current resource group:
SHOW JOBS;Output:
+-----------------+------------+-----------+
| Query ID | Job Status | Job Start |
+-----------------+------------+-----------+
| test_datagen2 | RUNNING | 310029 |
| filter1 | RUNNING | 1732491 |
| test_datagen | RUNNING | 540327 |
| sync_task | RUNNING | 47336395 |
| datagen_job | RUNNING | 87726 |
| filter2 | CANCELED | 38779 |
+-----------------+------------+-----------+The output includes the following columns:
| Column | Description |
|---|---|
Query ID | The unique identifier of the stream job. |
Job Status | The current state of the job. |
Job Start | The elapsed time since the job started. |