How do I set my profile in CRON job?

lolson33 · 12-06-2005, 11:20 AM

I am trying to setup my cron job to run sqlplus command but I kept get sqlplus command not found.
I think it didn't use the correct profile. How do use my profile when I am running cron job.

Thank you,

anon237 · 12-06-2005, 11:50 AM

Hi,

The users profile is never parsed when running a script from cron.

The easiest way (my opinion) to solve this: Put a snippet of code in the beginning of the script that is called.

Code:

# Needed for crontab, profile user not automatically parsed.
[[ "`/usr/bin/tty`" == "not a tty" ]] && . ~/.profile

The tty command tells which tty is connected, if none is (which is the case when running from cron) it will output the 'not a tty' message.

The above line will parse .profile when 'not a tty' is encountered.

Hope this helps.

tkedwards · 12-06-2005, 04:18 PM

Just put the full path to the sqlplus command in the cron job. Eg.

Code:

/usr/sbin/sqlplus

You can find out the path to it by running

Code:

which sqlplus

when logged in as yourself.