Re[2]: Ltrim?

Roland,

By now you've seen several messages showing you the cron syntax to get you task to start at the time you want. There is characteristic of cron that seems to catch first time users -- the environment settings. As a shell users you'll be used to having your .profile or .login
(or similar script depending on what shell you use) run and set up
your environment. And when you run "at" or "batch" jobs your current environment is passed on to those scripts. Job's that start from your "crontab" on the other hand, have a stripped down environment.

Try running a crontab command that just does a "set" and compare the email output to the environment that you have when you are at a shell prompt and the differences will be obvious. You'll probably see major differences in $PATH and $ORACLE_HOME, either of which could keep your script from executing properly.

The solution is to set your own environment every time a crontab task starts. I keep a stripped down version of my .profile that I name .cron_profile that has the environment I need to run sqlplus scripts. Then my crontab entries look like:

0 6 * * 1 . $HOME/.cron_profile; script_name

-rje

J> 0 6 * * 1 script_name

R> Hallo,
R> Anyone whom could help me how to write in cron when
R> scheduling the start of a unixprogram.

R> I would like that the unix script will run every monday on 6 am.

R> I have tried but it fails. Any suggestions, please help

R> Roland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Eskridge
  INET: bryny_at_dfweahs.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).