Hi Gurus,
I am new to ODI development and administration and currently require some expert's advice. I am using startscen/startcmd command to run a scenario. Although the script works fine and it triggers the corresponding scenario when run on terminal. The same is not achieved when run through crontab. Please have a look into the code
#!/bin/bash
export PATH=$PATH:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/u/a/ODI_HOME/oracledi/agent/bin
FILE10=/u/a/ODI_HOME/oracledi/agent/bin/e_load.txt
ARRAY10=( $(<"$FILE10") )
echo ${ARRAY10[0]}
if [ "${ARRAY10[0]}" = "Completed" ]
then
echo "Loaded">/u/a/ODI_HOME/oracledi/agent/bin/e_load.txt;
sh /u/a/ODI_HOME/oracledi/agent/bin/startscen.sh SCN_DATASRC 001 GLOBAL
#sh /u/a/ODI_HOME/oracledi/agent/bin/startcmd.sh OdiStartScen -SCEN_NAME=SCN_DATASRC -SCEN_VERSION=001 -CONTEXT=GLOBAL
else
echo "Test Unsuccessful"
fi
I have file of name e_load.txt which has a value like Completed. The script checks if the value is completed, then triggers the child script to run a scenario sh /u01/app/ODI_HOME/oracledi/agent/bin/startscen.sh PKG_DATASRC__REFRESHPROC 001 GLOBAL.
It works absolutely fine when run on terminal but the operator doesn't show and movement when the above script executes from crontab.
My confusion is, how will i know if the job is triggered or not.
If somebody has their own script please share:
My requirement is:
1. The scenerio/pkg should run every 10 mins.
2. Backend or even from ODI designer.
Regards,
Sourabh