RE: Could not run export utility from cron job

[Gary W. Parker]

Title: Could not run export utility from cron job

Make sure that you source your environment variables in the script.  At the least, set the $PATH variable to include the Oracle bin directory.

 

Jobs executing from CRON do not automatically source the .profile when they kick off.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Nguyen, David M
Sent: Wednesday, December 10, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L
Subject: Could not run export utility from cron job

I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to run as it does not recognize exp command.  Does someone have any idea?  Below is the command I run export manually.

$exp user/password tables.dmp

Thanks,
David