Few possible problems I can think of are;
PATH problem. Your file is not found. Add path for
COLD_BAKUP_FOR_QQADha.SQL
Use ksh infront of the shell command in crontab.
Priviledge to run from crontab.
- Alexander Ordonez <aordonez_at_ccss.sa.cr> wrote:
> try add the environment varriables into the script file!!!!!
>
>
> @L£K
> ------------------------------------------------------------
> Lic. Alexander Ordóñez Arroyo
> Caja Costarricense del Seguro Social
> Soporte Técnico - División de Informática
> Telefono: 295-2004, San José, Costa Rica
> Aordonez_at_ccss.sa.cr Icq# 30173325
>
> ------------------------------------------------------------
> The true is out there in WWW
>
> > -----Mensaje original-----
> > De: Kevin Lange [SMTP:kgel_at_ppoone.com]
> > Enviado el: Lunes 18 de Marzo de 2002 11:04 AM
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexander Ordonez
> INET: aordonez_at_ccss.sa.cr
>
> 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).
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammed Shakir
INET: mshakir08816_at_yahoo.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).
Received on Wed Mar 20 2002 - 22:53:19 CST
