DataStage Schedule - Oracle_Home not set when using 'every'

ds_user78 · Post by **ds_user78** » Tue Dec 18, 2007 4:44 pm

Hi I am facing an error in scheduling jobs through DataStage scheduler. When I schedule 'Today' and set a time , the ORACLE_HOME environment variable is set in the "Environment variable settings" when the job runs. If I use 'Every' and select some days and set a time, the ORACLE_HOME environment variable is not set in Environment variable settings. Am I missing some thing? Any ideas?

chulett · Post by **chulett** » Tue Dec 18, 2007 6:14 pm

'Today' jobs use 'at' while 'every' jobs use 'cron', but I don't see how that would in-and-of itself be an issue. Where are you setting ORACLE_HOME for DataStage - the proper place would be in your dsenv file.

ds_user78 · Post by **ds_user78** » Wed Dec 19, 2007 10:49 am

The ORACLE_HOME it set in dsenv. It is also there in .profile file of the unix user.