Hi,
I've created an SSH task in Visual Cron that attempts to run SQL Loader to insert a bunch of records from some csv files into our database. The issue I'm having is that the oracle installation path doesn't seem to be set in the user's PATH variable when I go through Visual Cron, so the job errors with the output "command not found". I do know, however, that the path is set in the user's profile on the server.
To give you an example of what I'm seeing, if I call export from Visual Cron I get the following value for the path variable:
declare -x PATH="/usr/local/bin:/bin:/usr/bin"
For the same user when logged in using Putty I get this value:
declare -x PATH="/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/oracle/product/10.2.0/db_1/bin"
Is there any reason the values are different?
We're running Visual Cron version 5.5.6 and the target database is Oracle 10.2.0 running on Linux.
If anyone can help, I'd be really grateful.
Thanks in advance,
Steve.
Edited by moderator
2013-07-04T12:25:39Z
|
Reason: Not specified