v.25.12Improvement

Introduce system

Introduce system.background_schedule_pool{,_log} to improve introspection of background jobs. #91157 (Azat Khuzhin).
Introduce system.background_schedule_pool and system.background_schedule_pool_log tables for enhanced introspection of ClickHouse background jobs.

Why it matters

The feature improves the observability of background jobs by providing detailed information about scheduled background tasks in ClickHouse. This helps users monitor and troubleshoot background activities more effectively.

How to use it

Query the new system tables system.background_schedule_pool to get current background job statuses and system.background_schedule_pool_log for historical logs of these jobs using standard SQL SELECT statements.