Search before asking

• I had searched in the issues and found no similar issues.

Description

At present, the observability of routine load job is relatively poor. This issue plans to enhance the observability of routine load from three tasks:

• Error msg can be displayed when show routine load job if exception happened. [improve](routine load) improve routine load observability #46238

• Add more metrics to observe the routine load job. [improve](routine load) add more metrics to observe the routine load job #48209

• Introduce routine load abnormal job monitor metrics. For a job that requires long-term stable operation, ensuring high availability is important, and monitoring for abnormal jobs is also crucial. The goal is to quickly perceive and locate which job is at fault when an exception occurs. [improve](routine load) introduce routine load abnormal job monitor metrics #48171

• Introduce routine load job statistic system table.Empower job with SQL query capability for statistical information, which can help user to identify abnormal jobs and other issues. [improve](information schema) introduce routine load job system table #48963

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct