monitoring-background-jobs - Monitor CockroachDB Background Job Health
Identifies failed, paused, and long-running CockroachDB background jobs using SHOW JOBS and SHOW AUTOMATIC JOBS.
Tags
Updated: 2026-10-01Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Identify failed jobs
- Find paused jobs
- Detect long-running jobs
- Inspect schema change jobs
- Monitor backup progress
- Check automatic job health
- Analyze job type patterns
Inputs
- SQL connection
- Job time window
- Job duration threshold
- CockroachDB cluster
Outputs
- Job health findings
- Failed job details
- Paused job details
- Long-running job details
- Job progress results
- Job status summaries
Requirements
- SQL access
- VIEWJOB privilege or CONTROLJOB role option
- SHOW JOBS support
- SHOW AUTOMATIC JOBS support