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

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

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/ma

RE: Crontab

crontab -e insert a line with Mi HH24 22-28 * 0 comandline - Hitarth -Original Message- Sent: Friday, March 23, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hi gurus, I want to schedule a script to run on the fourth sunday of the month. How can I do that ? TIA

Re: Crontab

Luc, If you do not find a more graceful way of doing this the following will work. Set 7 different lines in crontab all with 0 for the day-of-week. Then also set the day-of-month for each one from 22 to 28. Kind of cumbersome and clutters up crontab, but it will get you what you need. 22nd is

RE: Crontab

-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

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)" wr

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

?: Crontab ,HELP!!!

Hello All, Now my cronjob works fine.Thank you very much for your help. Regards, Saroj -OE³'ÌffbfZ[fW- ·ol: Michael Henderson [mailto:[EMAIL PROTECTED]] '-M"úZz: Wednesday, February 07, 2001 PM 01:35 ^¶æ: Multiple recipients of list ORACLE-L OE-¼: Re: Crontab ,HE

RV: CRONTAB JOB

<[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_

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 th

RE: CRONTAB JOB

s 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 :

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

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 >

RE: CRONTAB JOB

- 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 fr

Re: CRONTAB JOB

*/} at $(date)\n#" export ORACLE_HOME=/oracle/apps/oracle/8.1.5 export ORACLE_SID=MYDB export PATH=${PATH}:${ORACLE_HOME}/bin sqlplus /nolog < ovadx.com>cc:

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

RE: CRONTAB JOB

(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 j

RE: CRONTAB JOB

nes 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, i

RE: CRONTAB JOB

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 <[EMAIL PROTECTED]> wrote: > try add the environment varria

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

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

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

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;

RE: Crontab ,HELP!!!

fline 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. Whe

RE: Crontab ,HELP!!!

If this is root's crontab, then invoke script as oracle. ... su - oracle ... Don't forget "-" This will run script with oracle's environment. -Original Message- Sent: Tuesday, February 06, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Hello All,

Re: Crontab ,HELP!!!

H Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, February 06, 2001 11:35 PM Hi Saroj, crontab runs within its own environment (ie. it doesn't inherit an environment from any .profile or /etc/profile etc), so you wi

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 -- --- Henri

Re: Crontab ,HELP!!!

t; 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

RE: Crontab ,HELP!!!

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;

RE: Crontab ,HELP!!!

e-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

RE: crontab fpr NT

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 off

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. <> <> <> <> <> <> Regards, Patrice Bo

Re: crontab script problem

e 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 exe

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:

RE: crontab script problem

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

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