Crontab Usage
Just thought I would pass these links along to the list. It seems that there are a number of unix newbies on the list lately asking about automating jobs via cron. Hope these prove useful. Jared Automating Tasks with Cron and Crontab files http://itw.itworld.com/GoNow/a14724a55415a79856347a1 What is a cronjob, and how do I use it? http://itw.itworld.com/GoNow/a14724a55415a79856347a2 How to Use cron http://itw.itworld.com/GoNow/a14724a55415a79856347a4 CRONTAB(1) http://itw.itworld.com/GoNow/a14724a55415a79856347a3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: CRONTAB JOB
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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: CRONTAB JOB
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 [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -Mensaje original- De: Kevin Lange [SMTP:[EMAIL PROTECTED]] 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
CRONTAB JOB
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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RV: CRONTAB JOB
Hi, You have to write in QQAD_backupscript.sh: ORACLE_HOME=/u01/app/oracle/product/8.1.6; export ORACLE_HOME ORACLE_SID=TEST ; export ORACLE_SID $ORACLE_HOME/bin/sqlplus -s system/manager@QQAD @COLD_BAKUP_FOR_QQADha.SQL - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 15, 2002 1:28 PM 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Natalia Laracca INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: CRONTAB JOB
make sure your shell script is executable and put #!/path/to/sh as the first line in you script On Fri, 15 Mar 2002, 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: CRONTAB JOB
I think you also need to add -s to your sqlplus, so it runs in silent mode e.g. sqlplus -s system You might want to add | mailx -s Name of your table youremail.com to your cron job e.g. 04 17 * * 1-5 /opt/qqad/sql/QQAD_backupscript.sh | mailx -s Name of your table youremail.com so you get an email for your job. I also add into my cron scripts a display of when it starts and when it finishes. My 2 cents worth. Kathy -Original Message- Sent: Friday, March 15, 2002 10:27 AM To: Multiple recipients of list ORACLE-L make sure your shell script is executable and put #!/path/to/sh as the first line in you script On Fri, 15 Mar 2002, 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 21 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 [EMAIL PROTECTED] 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: CRONTAB JOB
make sure cron daemon is running On Fri, 15 Mar 2002, Paul Heely wrote: 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 21 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 [EMAIL PROTECTED] 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: CRONTAB JOB
Make sure to setup the environment. Try sourcing the oracle .profile and using the full path for sqlplus. Regards, -Daniel _ Daniel Harron Database Management IPsoft, Inc. [EMAIL PROTECTED] http://www.ip-soft.net/ Phone: 888.IPSOFT8 Fax: 212.353.2454 -Original Message- Sent: Friday, March 15, 2002 4:54 PM To: Multiple recipients of list ORACLE-L make sure cron daemon is running On Fri, 15 Mar 2002, Paul Heely wrote: 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 21 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 [EMAIL PROTECTED] 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Alex INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Daniel Harron INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: CRONTAB JOB
(What everybody else said plus) If you have root access (or get your sa to), vi /var/cron/log and look for your job. Under some situations cron will mail you a message and/or job output to you, so check your unix mail. The script template below should work (change as required). It's very very basic but should do the job. Don't forget to make the script executable with chmod +x backup.ksh: #!/bin/ksh # # Name: backup.ksh # DAYTIME=$(date +%Y%m%d_%H%M) JOB_LOG=/tmp/backup.log.${DAYTIME} exec 1${JOB_LOG} 21 echo #\n#Starting ${0##*/} at $(date)\n# export ORACLE_HOME=/oracle/apps/oracle/8.1.5 export ORACLE_SID=MYDB export PATH=${PATH}:${ORACLE_HOME}/bin sqlplus /nolog EOF connect system/manager @/path/to/my/script/first_script.sql @/path/to/my/script/second_script.sql exit; EOF echo #\n#Ending ${0##*/} at $(date)\n# mailx -s ${0##*/}:$(uname -n):${ORACLE_SID}:$(date) [EMAIL PROTECTED] ${JOB_LOG} # # END-OF-SCRIPT ### Hamid Alavi hamid.alavi@qu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ovadx.comcc: Sent by: Subject: CRONTAB JOB [EMAIL PROTECTED] m 03/15/02 09:28 AM Please respond to ORACLE-L 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@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 Cell818 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: crontab script problem
Thanks every-body. I found the culprit command in the .profile It wasksh -o emacswhich was creating a shell and causing problem. Also there were some terminal setting tset -I -Q , TERM=VT220, term=dec etc. which were not required while invoking the profile for a crontab. Cheers Rajesh -Original Message- Sent: Monday, April 16, 2001 11:06 PM To: Multiple recipients of list ORACLE-L When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin /sbi n:/e tc:/usr/bin:/usr/openwin/bin:/usr/ccs/bin:/usr/local/bin:/comm/BrxPU21:/ orac le/p roduct/8.0.4/bin:/usr/ucb:/usr/bin/nsr:/usr/bin:/usr/sbin:.:$PATH;export PATH OLDHOME=$ORACLE_HOME ORACLE_BASE=/oracle; export ORACLE_BASE ORACLE_SID=nyccp; export ORACLE_SID ORACLE_HOME=/oracle/product/8.0.4; export ORACLE_HOME ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS ORACLE_DOC=$ORACLE_HOME/doc; export ORACLE_DOC ORACLE_TERM=xsun5; export ORACLE_TERM ORACLE_LIB=$ORACLE_HOME/lib; export ORACLE_LIB CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:.:$ORACLE_HOME/jdbc/lib; export C LASSPATH TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN OPENWINHOME=/usr/openwin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:$ORACLE_HO ME/j dbc/ lib export LD_LIBRARY_PATH # TMPDIR=/tmp; export TMPDIR WORKDIR=/tmp; export WORKDIR # Put new ORACLE_HOME in path and remove old one case "$OLDHOME" in "") OLDHOME=$PATH ;;#This makes it so that null OLDHOME can't match esac#anything in next case statement case "$PATH" in *$OLDHOME/bin*) PATH=`echo $PATH | \ sed "s;$OLDHOME;$ORACLE_HOME;g"` ;; *$ORACLE_HOME/bin*) ;; *:) PATH=${PATH}$ORACLE_HOME/bin: ;; "") PATH=$ORACLE_HOME/bin ;; *) PATH=$PATH:$ORACLE_HOME/bin ;; esac PATH=/oracle/oper:$ORACLE_HOME/lib:/comm/local/jdk1.1.4/bin:$PATH export PATH -Original Message- Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: crontab script problem
When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin/sbi n:/e tc:/usr/bin:/usr/openwin/bin:/usr/ccs/bin:/usr/local/bin:/comm/BrxPU21:/orac le/p roduct/8.0.4/bin:/usr/ucb:/usr/bin/nsr:/usr/bin:/usr/sbin:.:$PATH;export PATH OLDHOME=$ORACLE_HOME ORACLE_BASE=/oracle; export ORACLE_BASE ORACLE_SID=nyccp; export ORACLE_SID ORACLE_HOME=/oracle/product/8.0.4; export ORACLE_HOME ORA_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS ORACLE_DOC=$ORACLE_HOME/doc; export ORACLE_DOC ORACLE_TERM=xsun5; export ORACLE_TERM ORACLE_LIB=$ORACLE_HOME/lib; export ORACLE_LIB CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip:.:$ORACLE_HOME/jdbc/lib; export C LASSPATH TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN OPENWINHOME=/usr/openwin LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:$ORACLE_HOME/j dbc/ lib export LD_LIBRARY_PATH # TMPDIR=/tmp; export TMPDIR WORKDIR=/tmp; export WORKDIR # Put new ORACLE_HOME in path and remove old one case "$OLDHOME" in "") OLDHOME=$PATH ;;#This makes it so that null OLDHOME can't match esac#anything in next case statement case "$PATH" in *$OLDHOME/bin*) PATH=`echo $PATH | \ sed "s;$OLDHOME;$ORACLE_HOME;g"` ;; *$ORACLE_HOME/bin*) ;; *:) PATH=${PATH}$ORACLE_HOME/bin: ;; "") PATH=$ORACLE_HOME/bin ;; *) PATH=$PATH:$ORACLE_HOME/bin ;; esac PATH=/oracle/oper:$ORACLE_HOME/lib:/comm/local/jdk1.1.4/bin:$PATH export PATH -Original Message- Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: crontab script problem
The "bad option" appears to be coming from somewhere in the .profile that you are executing. Can you forward that for further analysis? Also, the exact "crontab" command line would be helpful. -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Saturday, April 14, 2001 2:00 AM To: Multiple recipients of list ORACLE-L Subject:crontab script problem Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: William Rogge INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: crontab script problem
Rajesh, Instead of running the .profile for the oracle user, you might try invoking the oracle user. I don't think you're seeing the $ORACLE_HOME. Try something like: su - oracle "-c sqlplus -s"END system/manager END @/oracle/test2.sql Hope this helps. David A. Barbour Oracle DBA, OCP Rajesh Dayal wrote: Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
crontab script problem
Hi All, I am facing some problem while running sqlplus scripts from crontab. Env is Tru64 Unix 4.0f and Oracle 7.2.3. Through crontab all system commands run fine, but when I try to invoke sqlplus, it gives following error: /oracle/test1.sh: -o: bad option(s) Also I have executed .profile of Oracle user in the beginning of command. The commands written in /oracle/test1.sh is as follows, . /oracle/product/723/.profile sqlplus -s system/manager @/oracle/test2.sql Any help/suggestion would be greatly appreciated. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: crontab for NT
Dear Patrice, Thanks a Lot !!! Regards, Rajesh -Original Message- Sent: Monday, April 09, 2001 3:20 PM To: Rajesh Dayal Place the crontab file in Windows\system32 folder. crons.zip cron.zip cron1.htm cron2.htm cron3.htm cron4.htm Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography -Original Message- From: Rajesh Dayal [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 3:50 AM To: Multiple recipients of list ORACLE-L Subject:crontab fpr NT Hi all, Some days back I remember someone mentioning about crontab on NT. Please pass that utility directly to me. Appreciate your help. TIA, Rajesh [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: crontab fpr NT
you can use NT's at command. just say at /?..u will get the list of options - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -Original Message- Dayal Sent: Monday, April 09, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Hi all, Some days back I remember someone mentioning about crontab on NT. Please pass that utility directly to me. Appreciate your help. TIA, Rajesh [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Nihar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
crontab fpr NT
Hi all, Some days back I remember someone mentioning about crontab on NT. Please pass that utility directly to me. Appreciate your help. TIA, Rajesh [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Crontab
Title: Crontab Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: Crontab
Unfortunately the previous suggestion would run every Sunday AND on each day on the 22nd to the 28th. Your 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike -Original Message- crontab -e insert a line with Mi HH24 22-28 * 0 comandline - Hitarth -Original Message- I want to schedule a script to run on the fourth sunday of the month. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Crontab
Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Cetelem)" wrote: Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA - Luc Demanche CETELEM Tl.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Crontab - Ooops
Charlie, Some days are like that. You're right. Mike Hand had the right idea when he wrote: .. 2 choices are MM HH 22-28 * * (shell script checks for Sunday before proceeding) OR MM HH * * 0 (shell script checks for day of month between 22 and 28 before proceeding) Mike Charlie Mengler wrote: Just curious. Using your algorithm, what happens on those rare months where there are FIVE sundays? "David A. Barbour" wrote: Luc, One possible solution: Run the cron every Sunday and have the first part of your shell script check to see if that day's date plus seven days falls into another month. Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "DEMANCHE Luc (Cetelem)" wrote: Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA - Luc Demanche CETELEM Tl.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: David A. Barbour INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Crontab ,HELP!!!
Hello, We solved this problem by invoking our .profile first in the script Like : . /opt2/OraHome/.profile exp system/pwd file=/opt2/OraHome/exp/Billingfulldata.dmp full=y log=blb.txt good luck Regards Henrik -- --- Henrik Ekenberg Anoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenberg INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Crontab ,HELP!!!
The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing line. Don't forget the dot as the first character. . /usr/local/bin/profile.ora 2) Create a profile.ora file in /usr/local/bin (oropt/bin) and have it set up the platform specific environment variables that you need. Ours looks like this for SGI IRIX64. SGI_ABI=-64; export SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib; export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export CLASSPATH 3) In your cron scripts, put the following lines at the beginning to set up the environment. ORACLE_SID=sidname ; export ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK. /opt/bin/oraenv "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Hello All,I want to run a Job using crontab scheduling.The job is running butwith error like sqlplus and svrmgrl not found.When I am using the crontab script then it gives some error ,likesqlplus and svrmgrl not found.But ths same scripts manually working fine .So please tell me is there any path will setup to run the crontab . I amrunning the crontab from oracle id ,not from root.Please tell me what is the problem if i will run in orcale id. Where i willgive permission so that it will get the path of sqlplus and svrmgrl .I am sending the out put of cron .Please see it and tell me.our "cron" job on JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced the following output:Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J! ! ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not foundRegards,saroj.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y! ! ou want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices.
RE: Crontab ,HELP!!!
My god, I almost had a cow when I came in this morning. All my mail that has cron in it goes to its own folder as I have all oracle server mail routed to my exchange mail. I thought I was having system problems. -Original Message- Sent: Tuesday, February 06, 2001 8:35 PM To: Multiple recipients of list ORACLE-L Hi Saroj, crontab runs within its own environment (ie. it doesn't inherit an environment from any .profile or /etc/profile etc), so you will have to explicitly call them in your crontab job line (eg. . /etc/profile;script or command ) or even better declare the variables that the script will need in the beginning of the script and then just have the name of the script at the top. This one got me too. :-) Later, Mike. Michael Henderson, DBA http://www.nzoom.com DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466 [EMAIL PROTECTED] 02/07 5:10 pm Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Michael Henderson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Crontab ,HELP!!!
I use the following method to execute the profile so environment variables are all set just like when you manually run the script on the command line. 00 01 * * * ksh -c ". $HOME/.profile; /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup" Richard Ji -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck HamiltonSent: Wednesday, February 07, 2001 12:21 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Crontab ,HELP!!! The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing line. Don't forget the dot as the first character. . /usr/local/bin/profile.ora 2) Create a profile.ora file in /usr/local/bin (oropt/bin) and have it set up the platform specific environment variables that you need. Ours looks like this for SGI IRIX64. SGI_ABI=-64; export SGI_ABICOMPILER_DEFAULTS_PATH=$ORACLE_HOME/lib; export COMPILER_DEFAULTS_PATHLD_LIBRARY64_PATH=$ORACLE_HOME/lib; export LD_LIBRARY64_PATHLD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib:/usr/openwin/lib:/usr/ucblib; export LD_LIBRARY_PATHLD_LIBRARYN32_PATH=$ORACLE_HOME/lib32; export LD_LIBRARYN32_PATHCLASSPATH=$ORACLE_HOME/jdbc/lib/classes11.zip; export CLASSPATH 3) In your cron scripts, put the following lines at the beginning to set up the environment. ORACLE_SID=sidname ; export ORACLE_SIDORAENV_ASK=NO ; export ORAENV_ASK. /opt/bin/oraenv "Dash, Saroj (CAP,CEF)" [EMAIL PROTECTED] wrote: Hello All,I want to run a Job using crontab scheduling.The job is running butwith error like sqlplus and svrmgrl not found.When I am using the crontab script then it gives some error ,likesqlplus and svrmgrl not found.But ths same scripts manually working fine .So please tell me is there any path will setup to run the crontab . I amrunning the crontab from oracle id ,not from root.Please tell me what is the problem if i will run in orcale id. Where i willgive permission so that it will get the path of sqlplus and svrmgrl .I am sending the out put of cron .Please see it and tell me.our "cron" job on JLCSBLU1/db/oracle/oradata/scripts/SIEBELBKUP/coldbkupproduced the following output:Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001Started Cold Backup For jlisuser Wed Feb 7 11:05:01 J! ! ST 2001/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found/db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not foundRegards,saroj.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Dash, Saroj (CAP,CEF)INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list y! ! ou want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do You Yahoo!?Yahoo! Auctions - Buy the things you want at great prices.
Crontab ,HELP!!!
Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Crontab ,HELP!!!
Hi Saroj, crontab runs within its own environment (ie. it doesn't inherit an environment from any .profile or /etc/profile etc), so you will have to explicitly call them in your crontab job line (eg. . /etc/profile;script or command ) or even better declare the variables that the script will need in the beginning of the script and then just have the name of the script at the top. This one got me too. :-) Later, Mike. Michael Henderson, DBA http://www.nzoom.com DDI: +64-9-916 6941 Fax: +64-9-308 9614 Mob: 021-465 466 [EMAIL PROTECTED] 02/07 5:10 pm Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Michael Henderson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Crontab ,HELP!!!
Hi Saroj, You need to initialize the environment variables first in the cron file like ORACLE_SID, ORACLE_HOME etc. Also you will have to provide the Full path of the executables One of the sample cron file is something like this: banner BACKUP echo STARTING DAILY BACKUP ON `date`.. ORACLE_SID=pasi export ORACLE_SID ORACLE_HOME=/u03/app/oracle/8.1.6; export ORACLE_HOME /u03/app/oracle/8.1.6/bin/exp moh/hnh97 FULL=Y FILE=/u06/oradmp/allmoh.dmp GRANTS=Y INDEXES=Y LOG=/u06/oradmp/allmoh.log rm -f /u05/oracle8/arch/backctl /u03/app/oracle/8.1.6/bin/svrmgrl ! connect internal alter database backup controlfile to '/u05/oracle8/arch/backctl' ; alter system switch logfile ; exit ! mt rewind tar -cvp -f /dev/rmt0h /u06/oradmp/* tar -rvp /u05/oracle8/arch/arc* echo DAILY BACKUP COMPLETED SUCCESSFULLY echo PLEASE CHECK FOR ANY ERRORS .. mt rewind mt offline banner END-BACKUP HTH, Rajesh -Original Message- (CAP,CEF) Sent: Wednesday, February 07, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hello All, I want to run a Job using crontab scheduling.The job is running but with error like sqlplus and svrmgrl not found. When I am using the crontab script then it gives some error ,like sqlplus and svrmgrl not found. But ths same scripts manually working fine . So please tell me is there any path will setup to run the crontab . I am running the crontab from oracle id ,not from root. Please tell me what is the problem if i will run in orcale id. Where i will give permission so that it will get the path of sqlplus and svrmgrl . I am sending the out put of cron .Please see it and tell me. our "cron" job on JLCSBLU1 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup produced the following output: Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 Started Cold Backup For jlisuser Wed Feb 7 11:05:01 JST 2001 /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: sqlplus: not found /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup: /bin/svrmgrl: not found Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rajesh Dayal INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).