routine_load_job

Overview

Used to view information about routine load jobs.

Database

information_schema

Table Information

Column Name	Type	Description
JOB_ID	text	Job ID
JOB_NAME	text	Job name
CREATE_TIME	text	Job creation time
PAUSE_TIME	text	Job pause time
END_TIME	text	Job end time
DB_NAME	text	Database name
TABLE_NAME	text	Table name
STATE	text	Job status
CURRENT_TASK_NUM	text	Current number of subtasks
JOB_PROPERTIES	text	Job property configurations
DATA_SOURCE_PROPERTIES	text	Data source property configurations
CUSTOM_PROPERTIES	text	Custom property configurations
STATISTIC	text	Job statistics information
PROGRESS	text	Job progress information
LAG	text	Job delay information
REASON_OF_STATE_CHANGED	text	Reason for job status change
ERROR_LOG_URLS	text	Error log URLs
USER_NAME	text	Username
CURRENT_ABORT_TASK_NUM	int	Current number of failed tasks
IS_ABNORMAL_PAUSE	boolean	Whether paused by system (non-user pause)