DSXchange

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?

'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.

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