Running Wrong Profile from Script
Posted: Wed Sep 06, 2006 8:50 pm
Hi,
We have environment variable(EDW_HOME) at Unix level whose value is set up at profile (.profile) file which presents at home directory of a user. Value depends on user logged in.
Please find the values of EDW_HOME depends on the user.
User= etladmin
EDW_HOME=/hedw
User= etldev
EDW_HOME=/hedw_dev
User= etlsit
EDW_HOME=/hedw_sit
User= etluat
EDW_HOME=/hedw_uat
Now i created a script which creates a log file in the EDW_HOME directory and calling the script from job. The same job is imported into the following projects
Dev
Sit
Uat
I logged in to Dev project as etldev user and ran the job. But it tries to create a log file in /hedw directory. It happens with all the users and projects. i.e.always it tries to create in /hedw directory and looks like it is default. I wanted to create the log file based on user. If i execute the same script from command prompt it is working fine. Please let me know what could be the problem.
We have environment variable(EDW_HOME) at Unix level whose value is set up at profile (.profile) file which presents at home directory of a user. Value depends on user logged in.
Please find the values of EDW_HOME depends on the user.
User= etladmin
EDW_HOME=/hedw
User= etldev
EDW_HOME=/hedw_dev
User= etlsit
EDW_HOME=/hedw_sit
User= etluat
EDW_HOME=/hedw_uat
Now i created a script which creates a log file in the EDW_HOME directory and calling the script from job. The same job is imported into the following projects
Dev
Sit
Uat
I logged in to Dev project as etldev user and ran the job. But it tries to create a log file in /hedw directory. It happens with all the users and projects. i.e.always it tries to create in /hedw directory and looks like it is default. I wanted to create the log file based on user. If i execute the same script from command prompt it is working fine. Please let me know what could be the problem.