RE: CRONTAB JOB

Also ... are there other cron jobs for that ID that already work ?? It could be that your sysop needs to give privledges for that ID to run a cron job. Also, if the job is actually starting, check to make sure the environment is set right for it to find sqlplus. We have to run a small script at the begining of our jobs to setup the correct paths. As Suzy said, check mail to see if there are any outputs there that can help you debug.

-----Original Message-----
Sent: Monday, March 18, 2002 10:45 AM
To: Multiple recipients of list ORACLE-L

Cron has a log file, generally /var/cron/log (requires root privs to read it). Also check for mail of the user executing the cron job for errors.

Hamid Alavi wrote:
>
> 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: Suzy Vordos
  INET: lvordos_at_qwest.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: Kevin Lange
  INET: kgel_at_ppoone.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).