I have an existing .bat file where I call FDSLoader64.exe daily to update the following tables.
FDSLoader64.exe is supposed to download the latest txt files related to resepctives from FTP and download them.
Once the update is successful, FDSLoader64.exe updates the metadata tables in which one can know if the update was successful or not.
To do this I have created a PROGRAM in Oracle 11g as follows
TO START DBMS_SCHEDULER.DISABLE (name => FDS_DEMO.FF_V3, force => TRUE); DBMS_SCHEDULER.ENABLE (name => FDS_DEMO.FF_V3 & # 39;) END;
Create a schedule for this, it should work every day at 11:30.
TO START DBMS_SCHEDULER.set_attribute (name => "FDS_DEMO". "DAILY_9AM", attribute => "repeat_interval", value => & # 39; FREQ = DAILY; BYDAY = MON, FUTURE, MARI, GAME , FRI; BY, FRI; BYHOUR = 11; BYMINUTE = 30; BYSECOND = 0;); END;
Finally I have created a job who runs the program using the calendar.
TO START DBMS_SCHEDULER.set_attribute (name => "FDS_DEMO". "FF_V3_GENESIS", attribute => job_priority, value => 1); END; /
The calendar was successfully run at 11:30 am on June 24, 2019. According to the metadata tables, we can confirm that the data was successfully uploaded to the tables, but when I see the content of user_scheduler_job_run_details, it displays the results as following.
** The complete error code is as follows. ** "ORA-27369: EXECUTABLE job failed with exit code: there is no job process children to wait. STANDARD_ERROR = "2019/06/24 11:30:16 INFO>: config.xml is at the latest version 2.10, in progress. 2019/06/24 11:30:21 INFO>: FDSLoader version 220.127.116.11 2019/06/24 11:30:21 INFO>: Dump directory D: FDSLoader d ""