Re: CRONTAB JOB

Check the cron/crontab man pages to see what environment is setup for jobs run from cron. You can also re-direct any output from you script to a file, i.e.
/opt/qqad/sql/QQAD_backupscript.sh > /some_file 2>&1 This should send STDOUT and STDERR to /some_file.

Inside your script you can also show you current environment, env, printenv, set, etc. The output can then be re-directed to a file.

We had an issue on AIX where the environment that cron run jobs used was different than the one you got just by logging in.

--
Paul


----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, March 15, 2002 11:28 AM




> Hi All,

>

> I have a crontab job but this job never started, I have no idea what's

> wrong, actualy i am not a unix person, here is the job:

> cron job name is :  qqad.cron

> 04 17 * * 1-5  /opt/qqad/sql/QQAD_backupscript.sh

> and here is the QQAD_backupscript.sh (in /opt/qqad/sql)

>

> sqlplus system/manager_at_QQAD @COLD_BAKUP_FOR_QQADha.SQL;     cold_back.sql

is


> generated by COLD_BAKUP_FOR_QQADha.SQL

>

> @/opt/qqad/sql/cold_back.sql;

>

> If I run the job manualy it is going OK but crontab never start.

> Any Idea??

>

>

> Hamid Alavi

> Office 818 737-0526

> Cell    818 402-1987

>

> The information contained in this message and any attachments is intended

> only for the use of the individual or entity to which it is addressed, and

> may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from

> disclosure under applicable law. If you have received this message in

error,


> you are prohibited from copying, distributing, or using the information.

> Please contact the sender immediately by return e-mail and delete the

> original message from your system.

> --

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> --

> Author: Hamid Alavi

>   INET: hamid.alavi_at_quovadx.com

>

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> 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).

>

>



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Heely
  INET: pheely_at_acm.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).