I'm Trying to get oracle DB data using DB Connect app and I have successfully scheduled my job and set up my connection. When executing query in the Preview Data window my results are as expected. I
Now comes the problem, the job is executing without error and on time from what I can see in the DB Connect Input Health tab, however, none of my data is being ingested.
when i was trying to ingest using Input Type rising but getting error as invalid column index
let me know settings while selecting rising input type and why data was not getting while selecting batch
JOID JOB_NAME JOB_GROUP RUN_NUM NTRY RUN_MACHINE START_TIME END_TIME RUNTIME STATUS EXIT_CODE
| 1 |
126692 |
PNB-SOLW-MSSQL-DELETE-ACCOUNTS-OVER-90-DAYS |
SOLW |
400894570 |
1 |
|
2022/11/28 03:00:01 |
2022/11/28 03:00:17 |
16 |
SUCCESS |
0 |
2 |
126692 |
PNB-SOLW-MSSQL-DELETE-ACCOUNTS-OVER-90-DAYS |
SOLW |
400502118 |
1 |
|
2022/11/25 03:00:00 |
2022/11/25 03:00:13
|
