Windows Task scheduler does not write data into the MySQL db
I have talend job that gets data from arest API and inserts into MySQL DB. WHen I run the job from Talend Studio manually, it inserts data into the db but when I run the job from command line or task scheduler, it inserts data but the db goes blank after the run is complete. Not able to understand why is this happening?
Do you have any deletes in this job? If not, I cannot understand why this would be happening. Unless when you run this on the command line, there are other things that are part of that command line run. Maybe another job that runs afterwards?
If data is written to a DB so that you can see it in the DB, unless there is a deletion taking place, the data will remain there.
