Skip to main content
Version: Candidate-4.0

routine_load_jobs

routine_load_jobs provides information about routine load jobs.

The following fields are provided in routine_load_jobs:

FieldDescription
IDID of the routine load job.
NAMEName of the routine load job.
CREATE_TIMECreation time of the routine load job.
PAUSE_TIMEPause time of the routine load job.
END_TIMEEnd time of the routine load job.
DB_NAMEName of the database to which the routine load job belongs.
TABLE_NAMEName of the table to which the data is loaded.
STATEState of the routine load job.
DATA_SOURCE_TYPEType of the data source.
CURRENT_TASK_NUMNumber of current tasks.
JOB_PROPERTIESProperties of the routine load job.
DATA_SOURCE_PROPERTIESProperties of the data source.
CUSTOM_PROPERTIESCustom properties of the routine load job.
STATISTICSStatistics of the routine load job.
PROGRESSProgress of the routine load job.
REASONS_OF_STATE_CHANGEDReasons for state changes.
ERROR_LOG_URLSURLs of error logs.
TRACKING_SQLSQL statement for tracking.
OTHER_MSGOther messages.
LATEST_SOURCE_POSITIONLatest source position in JSON format.
OFFSET_LAGOffset lag in JSON format.
TIMESTAMP_PROGRESSTimestamp progress in JSON format.