run_all_import_data_bi_indoteknik
/
-
2023/03/08 11:02:31.082
-
2023/03/08 11:02:31.082
ID_JOB
Y
ID_JOB
CHANNEL_ID
Y
CHANNEL_ID
JOBNAME
Y
JOBNAME
STATUS
Y
STATUS
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
STARTDATE
Y
STARTDATE
ENDDATE
Y
ENDDATE
LOGDATE
Y
LOGDATE
DEPDATE
Y
DEPDATE
REPLAYDATE
Y
REPLAYDATE
LOG_FIELD
Y
LOG_FIELD
EXECUTING_SERVER
N
EXECUTING_SERVER
EXECUTING_USER
N
EXECUTING_USER
START_JOB_ENTRY
N
START_JOB_ENTRY
CLIENT
N
CLIENT
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
JOBNAME
Y
TRANSNAME
JOBENTRYNAME
Y
STEPNAME
LINES_READ
Y
LINES_READ
LINES_WRITTEN
Y
LINES_WRITTEN
LINES_UPDATED
Y
LINES_UPDATED
LINES_INPUT
Y
LINES_INPUT
LINES_OUTPUT
Y
LINES_OUTPUT
LINES_REJECTED
Y
LINES_REJECTED
ERRORS
Y
ERRORS
RESULT
Y
RESULT
NR_RESULT_ROWS
Y
NR_RESULT_ROWS
NR_RESULT_FILES
Y
NR_RESULT_FILES
LOG_FIELD
N
LOG_FIELD
COPY_NR
N
COPY_NR
ID_BATCH
Y
ID_BATCH
CHANNEL_ID
Y
CHANNEL_ID
LOG_DATE
Y
LOG_DATE
LOGGING_OBJECT_TYPE
Y
LOGGING_OBJECT_TYPE
OBJECT_NAME
Y
OBJECT_NAME
OBJECT_COPY
Y
OBJECT_COPY
REPOSITORY_DIRECTORY
Y
REPOSITORY_DIRECTORY
FILENAME
Y
FILENAME
OBJECT_ID
Y
OBJECT_ID
OBJECT_REVISION
Y
OBJECT_REVISION
PARENT_CHANNEL_ID
Y
PARENT_CHANNEL_ID
ROOT_CHANNEL_ID
Y
ROOT_CHANNEL_ID
N
Start
SPECIAL
Y
N
N
0
0
60
12
0
1
1
N
Y
0
176
128
accurate
TRANS
filename
/home/superman/runapps/import_accurate_to_data_warehouse.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
320
128
adempiere
TRANS
filename
/home/superman/runapps/import_adempiere_to_data_warehouse.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
480
128
odoo
TRANS
filename
/home/superman/runapps/import_odoo_14_to_data_warehouse.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
624
128
refresh_materialized_view
TRANS
filename
/home/superman/runapps/refresh_materialized_view.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
752
128
Delete files
DELETE_FILES
N
N
/home/superman/data
.+\.xls
/home/superman/data
.+\.xlsx
N
Y
0
752
256
import fixco
TRANS
filename
/home/superman/runapps/import_accurate_fixco_to_data_warehouse.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
896
128
refresh mv fixco
TRANS
filename
/home/superman/runapps/refresh_materialized_view_fixco.ktr
N
N
N
N
N
N
N
N
Basic
N
N
Y
N
N
N
Pentaho local
N
Y
N
Y
0
896
256
Start
accurate
0
0
Y
Y
Y
accurate
adempiere
0
0
Y
Y
N
adempiere
odoo
0
0
Y
Y
N
odoo
refresh_materialized_view
0
0
Y
Y
N
refresh_materialized_view
import fixco
0
0
Y
Y
N
import fixco
refresh mv fixco
0
0
Y
Y
N
refresh mv fixco
Delete files
0
0
Y
Y
N