routine_load_jobs
routine_load_jobs provides information about routine load jobs.
The following fields are provided in routine_load_jobs:
| Field | Description |
|---|---|
| ID | ID of the routine load job. |
| NAME | Name of the routine load job. |
| CREATE_TIME | Creation time of the routine load job. |
| PAUSE_TIME | Pause time of the routine load job. |
| END_TIME | End time of the routine load job. |
| DB_NAME | Name of the database to which the routine load job belongs. |
| TABLE_NAME | Name of the table to which the data is loaded. |
| STATE | State of the routine load job. |
| DATA_SOURCE_TYPE | Type of the data source. |
| CURRENT_TASK_NUM | Number of current tasks. |
| JOB_PROPERTIES | Properties of the routine load job. |
| DATA_SOURCE_PROPERTIES | Properties of the data source. |
| CUSTOM_PROPERTIES | Custom properties of the routine load job. |
| STATISTICS | Statistics of the routine load job. |
| PROGRESS | Progress of the routine load job. |
| REASONS_OF_STATE_CHANGED | Reasons for state changes. |
| ERROR_LOG_URLS | URLs of error logs. |
| TRACKING_SQL | SQL statement for tracking. |
| OTHER_MSG | Other messages. |
| LATEST_SOURCE_POSITION | Latest source position in JSON format. |
| OFFSET_LAG | Offset lag in JSON format. |
| TIMESTAMP_PROGRESS | Timestamp progress in JSON format. |