|There is a batch script placed at a windows box at a specified location. Control M contains the location of the batch script and triggers the script which runs three schedulers.|
Totally 3 different schedulers + 2 receiver are running in the triggered job in Control M:
1)Give up scheduler
2)Price scheduler + Receivers
3)TM Trade scheduler
Currently in this process while running through control M, the price scheduler is correctly running and the price is flowing correctly into database from time to time(as checked the change in price in database). The Give up scheduler and TM trade scheduler is started correctly and I have checked all the starts logs that are updated into database correctly on the triggered time too(please refer enclosed below screenshot). As checked, when scheduler is running through Control M we are unable to find if it is getting updated properly on the ‘notis’ system path and through SQL loader the files are not imported to database. This is why the data are not being reflected into front end. Whereas, when we run it manually the data are correctly imported through SQL loader into database and in front end the data are correctly flowed.
So, now we have to identify why the files are not indentified in ‘notis’ system path and also why it is not imported through SQL loader to database while running Control M.
Notis system is a file exchange server.
Whenever we trigger the job from Control M, the give up scheduler redirects for the credentails to connect to the 'notis' system.
Can somebody please advice where do we place the username and password for the Notis exchange system in the script so that the give up scheduler does not redirect us for the credentials and the process can be automated through Control M.
Please find the script below:
echo "Starting Dolphin schedulers and price feed running"
START "SCHEDULERS" /B "C:\DolphinRMS2\Automation\GiveupTAP\GiveupTAPScheduler.exe"
START "RECEIVER" /B "C:\DolphinRMS2\Automation\IRF Executer\CM\NB Receiver.exe"
START "RECEIVER" /B "C:\DolphinRMS2\Automation\IRF Executer\FNO\NB Receiver.exe"
START "PRICEFEED" /B "C:\DolphinRMS2\Automation\Price-Scheduler\Price Feed Capture.exe"
START "SCHEDULERS" /B "C:\DolphinRMS2\Automation\TMTradeTAPScheduler\TMTradeTAPScheduler.exe"