Job Management
Job management commands are used to view, describe, and cancel running or completed SQL jobs in Lakehouse.
In This Chapter
| Page | Description |
|---|
| SHOW JOBS | List jobs; supports filtering by status, time, cluster, and other conditions |
| DESC JOB | View detailed information for a single job, including the execution plan and error messages |
| CANCEL JOB | Cancel a job that is currently running |
Common Operations
View Jobs
-- View all jobs (most recent records)
SHOW JOBS;
-- View running jobs
SHOW JOBS WHERE status = 'RUNNING';
-- View failed jobs
SHOW JOBS WHERE status = 'FAILED' LIMIT 20;
-- View jobs on a specific cluster
SHOW JOBS WHERE virtual_cluster = 'my_cluster' LIMIT 50;
View Job Details
-- View detailed information for a specific job (including error messages)
DESC JOB 'job_id_here';
Cancel a Job
-- Cancel a running job
CANCEL JOB 'job_id_here';
