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
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
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
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
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
-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
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
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
Hello All,
Now my cronjob works fine.Thank you very much for your help.
Regards,
Saroj
-OE³'ÌffbfZ[fW-
·ol: Michael Henderson [mailto:[EMAIL PROTECTED]]
'-M"úZz: Wednesday, February 07, 2001 PM 01:35
^¶æ: Multiple recipients of list ORACLE-L
OE-¼: Re: Crontab ,HE
<[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_
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
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 :
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
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 >
-
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
*/} 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:
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
(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
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
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
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
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
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
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;
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
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,
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
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
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
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;
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
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
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
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
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:
---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
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
37 matches
Mail list logo