We are migrating jobs over to a new 7.5 server. So far, everything works except our before and after scripts.
The only thing I notice that is different between our 5.2.2 server (where these worked) and this one is that you have to put ./ before you can run anything. So, to run this from the command line on the 5.2.2 server you type drop_indexes.txt and on 7.5 you have to type ./drop_indexes.txt.
Running from the command line works. I tried putting ./ in the Job Properties Input Value but it didn't work. I also set the drop_indexes.txt file to chmod 777. Help!
PROTDdwFactLoader..BeforeJob (ExecSH): Error when executing command: /datastage/Projects/DRDWSrProtDev/ds_scripts/drop_indexes.txt
*** Output from command was: ***
SH: /datastage/Projects/DRDWSrProtDev/ds_scripts/drop_indexes.txt: not found