I have created some sqoop jobs and have set record password to true. I am running these jobs through oozie. I have 10-12 jobs which I am running from oozie and after executing around 6-7 jobs, it throws
Could not connect to user@host (using password NO).
How come it stops using the recorded password after executing a couple of times? When I recreate job again, ti works fine a couple of time 'and then again the same problem with the same error.
I really need to know what is causing this issue?There has to be a valid reason for this,ain't it? Recreating the job is certainly not the fix neither is restarting the SQL server I am connecting to.