monitoring-background-jobs
Monitors CockroachDB background job health by identifying failed, paused, and long-running jobs using SHOW JOBS and SHOW AUTOMATIC JOBS. Surfaces schema changes, backups/restores, automatic statistics collection, and SQL stats compaction jobs without DB Console access. Use when investigating schema change delays, failed backups, or automatic job issues.
- Version
- 1.0
- Compatibility
- Requires SQL access with VIEWJOB privilege or CONTROLJOB role option for cluster-wide visibility. Uses SHOW JOBS and SHOW AUTOMATIC JOBS (production-safe).
Pinned to revision 4e8964e24a5a, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/monitoring-background-jobs/SKILL.md
- skills/monitoring-background-jobs/cockroachdb-observability-and-diagnostics/profiling-statement-fingerprints/SKILL.md
- skills/monitoring-background-jobs/cockroachdb-observability-and-diagnostics/triaging-live-sql-activity/SKILL.md
- skills/monitoring-background-jobs/references/job-states.md
- skills/monitoring-background-jobs/references/job-types.md
- skills/monitoring-background-jobs/references/permissions.md
- skills/monitoring-background-jobs/references/sql-query-variations.md
Every link opens the file at its source, pinned to the revision this page describes.