Re: Unix - scheduling - I know this, it's a UNIX system

2002-07-03 Thread Brian_P_MacLean


This will run the job every 28 daze at 1am.  If that's not exactly the
definition of every 4th week let me know and I'll work something out.  Also
note that you will have an anomaly at the end of leap years.


0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] 
/path/to/my/job/the_job'







   
 
  Roland.Skoldblom@
 
  ica.se   To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Unix - scheduling 
 
   
 
   
 
  07/02/02 01:43 AM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 




Hallo,

anyone who has a good example on how to write in the crontab if you want to
schedule a job to run every four week.
Is it possible to do that in unix cron job schedule.

Thanks in advance


Roland

--






-- 
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: Unix - scheduling - I know this, it's a UNIX system

2002-07-03 Thread lembark



-- [EMAIL PROTECTED] on 07/03/02 14:13:30 -0800

 
 This will run the job every 28 daze at 1am.  If that's not exactly the
 definition of every 4th week let me know and I'll work something out.  Also
 note that you will have an anomaly at the end of leap years.
 
 
 0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] 
 /path/to/my/job/the_job'

   %j day of year (001..366)

Two problems are not adjusting the initial start date 
(simple enough, adding a constant) and 365 % 28 != 0.
The last will give you an extended period once per
year. The only reliable way to handle this requries
gnu date, which has %s == system time in GMT:

[ $(( ($(date +%s) + $INITIAL_DATE_OFFSET) % 2419200 )) -eq 0 ]  /blah;

Is a bit grimy but works. The wallclock time may shift
slightly during the DST correction but the basic interval
works.

The one-second resolution can cause problems if crond
doesn't run exactly on the minute; this can be corrected
by taking the integer portion after dividing by 60 and 
comparing that.

At which point it's better to give up on cron entirely 
and use at, which does all of this mess for you and 
handles cron outages also (which the above doesn't).

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Unix - scheduling - I know this, it's a UNIX system

2002-07-03 Thread Brian_P_MacLean


I knew about the start date/offset thingy, but hey, ya gotta leave him
something to figure out

As for the end of year, yeah, you're right.  Every year is a problem.
Since this is an Oracle news list we could just call Oracle from our shell
script and ask for the daze since some constant date and today, do the mod
28 math, and if it's zero, confinue to run the script, otherwise end.

I was just trying to show an inventive way to use cron.

Have a good 4th all.



   
 
  [EMAIL PROTECTED]
 
  om   To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  Sent by: cc: 
 
  [EMAIL PROTECTED] Subject:  Re: Unix - scheduling - I 
know this, it's a UNIX system
   
 
   
 
  07/03/02 03:39 PM
 
  Please respond to
 
  ORACLE-L 
 
   
 
   
 






-- [EMAIL PROTECTED] on 07/03/02 14:13:30 -0800


 This will run the job every 28 daze at 1am.  If that's not exactly the
 definition of every 4th week let me know and I'll work something out.
Also
 note that you will have an anomaly at the end of leap years.


 0 1 * * * /usr/bin/ksh -c '[ $(($(date '+\%j') \% 28)) -eq 0 ] 
 /path/to/my/job/the_job'

   %j day of year (001..366)

Two problems are not adjusting the initial start date
(simple enough, adding a constant) and 365 % 28 != 0.
The last will give you an extended period once per
year. The only reliable way to handle this requries
gnu date, which has %s == system time in GMT:

[ $(( ($(date +%s) + $INITIAL_DATE_OFFSET) % 2419200 )) -eq 0 ] 
/blah;

Is a bit grimy but works. The wallclock time may shift
slightly during the DST correction but the basic interval
works.

The one-second resolution can cause problems if crond
doesn't run exactly on the minute; this can be corrected
by taking the integer portion after dividing by 60 and
comparing that.

At which point it's better to give up on cron entirely
and use at, which does all of this mess for you and
handles cron outages also (which the above doesn't).

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
--
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).





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



Unix - scheduling

2002-07-02 Thread Roland . Skoldblom

Hallo,

anyone who has a good example on how to write in the crontab if you want to schedule a 
job to run every four week.
Is it possible to do that in unix cron job schedule.

Thanks in advance


Roland

-- 
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: Unix - scheduling

2002-07-02 Thread Stephane Faroult


Hallo,

anyone who has a good example on how to write in
the crontab if you want to schedule a job to run
every four week.
Is it possible to do that in unix cron job
schedule.

Thanks in advance


Roland


Roland,

   Please, just for once, couldn't you try to figure out things by yourself and type 
'man crontab'? I am naively optimistic about human nature but you make me despair. I'd 
be really happy to read one day from one of your posts something you have picked up in 
a doc I have not had time to read myself. Really.

Regards,

Stephane Faroult
Oriole
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroul
  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: Unix - scheduling

2002-07-02 Thread Nils Höglund


 anyone who has a good example on how to write in the crontab if you want to schedule 
a job to run every four week.
 Is it possible to do that in unix cron job schedule.

Yes, it is very possible.

Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):

0 */4 * * * your_command

This will run your_command every four hours (first field which minutes,
second field in which hours)

You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)

-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: Unix - scheduling

2002-07-02 Thread Jared Still


Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.

'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.

Jared

On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
  anyone who has a good example on how to write in the crontab if you want
  to schedule a job to run every four week. Is it possible to do that in
  unix cron job schedule.

 Yes, it is very possible.

 Run 'crontab -e' as apropeate user. Your $EDITOR will open.
 Write as described in crontab(5) manual ('man 5 crontab'):

 0 */4 * * * your_command

 This will run your_command every four hours (first field which minutes,
 second field in which hours)

 You can also edit the /etc/crontab-file (if avaible on your system.) This
 file has a different syntax (you specify the user who is going to run the
 command too.)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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: Unix - scheduling

2002-07-02 Thread lembark



-- [EMAIL PROTECTED] on 07/02/02 00:43:19 -0800

 Hallo,
 
 anyone who has a good example on how to write in the crontab if you want to
 schedule a job to run every four week. Is it possible to do that in unix cron
 job schedule.

Monthly is doable. Every 28 days requires using at,
or a more flexable scheduling tool. That or cron the job
daily and have it decide whether 28 days have passed 
since it last ran (e.g., based on a time string stored
in a file).

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Unix - scheduling

2002-07-02 Thread lembark



-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800

 0 */4 * * * your_command

$ man 5 cronttab;


 The time and date fields are:

  field  allowed values
  -  --
  minute 0-59
  hour   0-23
  day of month   1-31
  month  1-12 (or names, see below)
  day of week0-7 (0 or 7 is Sun, or use names)

   A field may be an asterisk (*), which always stands for ``first-last''.

   Ranges  of numbers are allowed.  Ranges are two numbers separated with a
hyphen.  The specified range
   is inclusive.  For example, 8-11 for an ``hours'' entry specifies
execution at hours 8, 9, 10 and 11.

   Lists  are  allowed.   A  list  is  a  set  of  numbers  (or  ranges)
separated by commas.  Examples:
   ``1,2,5,9'', ``0-4,8-12''.
:


Question: how does 0 */4 * * * cause something to run every
4 weeks? Unless your version has a different field order. It
might work to try * */628 * * * but I'm not sure that cron
allows n24 for the hourly divisor.

The combination of date and weekday can approximate the 4-week
cycle.



--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
--
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: Unix - scheduling

2002-07-02 Thread Alex

http://www.superscripts.com/tutorial/crontab.html

On Tue, 2 Jul 2002 [EMAIL PROTECTED] wrote:

 Hallo,

 anyone who has a good example on how to write in the crontab if you want to schedule 
a job to run every four week.
 Is it possible to do that in unix cron job schedule.

 Thanks in advance


 Roland

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


-- 
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: Unix - scheduling

2002-07-02 Thread Richard Huntley
Title: RE: Unix - scheduling





Is a strick 14 day rule absolutely necessary, if not...a much more hassle free way would be to
simply schedule the cronjob to run on the 1st and 15th of each month, i.e.


# Min Hr Day Mon WkDay Command
0 0 1,15 * * script




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Unix - scheduling





-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800


 0 */4 * * * your_command


$ man 5 cronttab;



 The time and date fields are:


 field allowed values
 - --
 minute 0-59
 hour 0-23
 day of month 1-31
 month 1-12 (or names, see below)
 day of week 0-7 (0 or 7 is Sun, or use names)


 A field may be an asterisk (*), which always stands for ``first-last''.


 Ranges of numbers are allowed. Ranges are two numbers separated with a
hyphen. The specified range
 is inclusive. For example, 8-11 for an ``hours'' entry specifies
execution at hours 8, 9, 10 and 11.


 Lists are allowed. A list is a set of numbers (or ranges)
separated by commas. Examples:
 ``1,2,5,9'', ``0-4,8-12''.
:



Question: how does 0 */4 * * * cause something to run every
4 weeks? Unless your version has a different field order. It
might work to try * */628 * * * but I'm not sure that cron
allows n24 for the hourly divisor.


The combination of date and weekday can approximate the 4-week
cycle.




--
Steven Lembark 2930 W. Palmer
Workhorse Computing Chicago, IL 60647
 +1 800 762 1582
-- 
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: Unix - scheduling

2002-07-02 Thread Hand, Michael T

Roland,
crontab alone will not meet your needs.  Hint: check the date command and
MOD type fuctionality in a shell script.
Good luck,
Mike

-Original Message-
Sent: Tuesday, July 02, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L



Hallo,

anyone who has a good example on how to write in
the crontab if you want to schedule a job to run
every four week.
Is it possible to do that in unix cron job
schedule.

Thanks in advance


Roland


Roland,

   Please, just for once, couldn't you try to figure out things by yourself
and type 'man crontab'? I am naively optimistic about human nature but you
make me despair. I'd be really happy to read one day from one of your posts
something you have picked up in a doc I have not had time to read myself.
Really.

Regards,

Stephane Faroult
Oriole
-- 
-- 
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: Unix - scheduling

2002-07-02 Thread Michael Cupp

He specified that 0 */4 * * * would cause it to run every 4 hours.  He provided an 
example.

-Original Message-
Sent: Tuesday, July 02, 2002 11:13 AM
To: Multiple recipients of list ORACLE-L




-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 -0800

 0 */4 * * * your_command

$ man 5 cronttab;


 The time and date fields are:

  field  allowed values
  -  --
  minute 0-59
  hour   0-23
  day of month   1-31
  month  1-12 (or names, see below)
  day of week0-7 (0 or 7 is Sun, or use names)

   A field may be an asterisk (*), which always stands for ``first-last''.

   Ranges  of numbers are allowed.  Ranges are two numbers separated with a 
hyphen.  The specified range
   is inclusive.  For example, 8-11 for an ``hours'' entry specifies execution at 
hours 8, 9, 10 and 11.

   Lists  are  allowed.   A  list  is  a  set  of  numbers  (or  ranges)
separated by commas.  Examples:
   ``1,2,5,9'', ``0-4,8-12''.
:


Question: how does 0 */4 * * * cause something to run every
4 weeks? Unless your version has a different field order. It might work to try * 
*/628 * * * but I'm not sure that cron allows n24 for the hourly divisor.

The combination of date and weekday can approximate the 4-week cycle.



--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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).


This message originated from the internet.  Its originator may not be who they claim 
to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Cupp
  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: Unix - scheduling

2002-07-02 Thread Richard Huntley
Title: RE: Unix - scheduling



U...think they slipped something into my Mountain 
Dew while I wasn't looking so that they could
log 
into production directly via SQL*Plus and make some manual changes...I must have 
still been
regaining my senses when I sent this...sorry 
:)

-Original Message-From: Richard Huntley 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 02, 2002 11:58 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Unix - scheduling
Is a strick 14 day rule absolutely necessary, if not...a much 
more hassle free way would be to simply schedule the 
cronjob to run on the 1st and 15th of each month, i.e. 
# Min Hr Day Mon WkDay Command 0 0 
1,15 * * script 
-Original Message- From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: 
Re: Unix - scheduling 
-- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 
-0800 
 0 */4 * * * your_command 
$ man 5 cronttab; 
 The time and date fields are: 

 
field allowed 
values  
- 
--  
minute 0-59  
hour 0-23 
 
day of month 1-31  
month 1-12 (or names, see 
below)  
day of week 0-7 (0 or 7 is Sun, or use names) 
 A field may be an asterisk 
(*), which always stands for ``first-last''. 
 Ranges of numbers are 
allowed. Ranges are two numbers separated with a hyphen. The specified range  is inclusive. For example, 
8-11 for an ``hours'' entry specifies execution at hours 
8, 9, 10 and 11. 
 Lists are 
allowed. A list is a set of 
numbers (or ranges) separated by 
commas. Examples:  ``1,2,5,9'', ``0-4,8-12''. 
: 
Question: how does "0 */4 * * *" cause something to run 
every 4 weeks? Unless your version has a different field 
order. It might work to try "* */628 * * *" but I'm not 
sure that cron allows n24 for the hourly 
divisor. 
The combination of date and weekday can approximate the 
4-week cycle. 
-- Steven 
Lembark 
2930 W. Palmer Workhorse 
Computing 
Chicago, IL 60647  
+1 800 762 1582 -- 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: Unix - scheduling

2002-07-02 Thread Ron Thomas


0 */4 * * * your_command

The */4 must be linux.  This is not available on HP-UX 11.0.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
The problem with some people is that when they aren't drunk, they're sober.  
--William Butler
Yeats.


   

  [EMAIL PROTECTED]

  Sent by: To:   [EMAIL PROTECTED]  

  [EMAIL PROTECTED] cc: 

   Subject:  Re: Unix - scheduling 

   

  07/02/02 04:28 AM

  Please respond to

  ORACLE-L 

   

   






 anyone who has a good example on how to write in the crontab if you want to schedule 
a job to run
every four week.
 Is it possible to do that in unix cron job schedule.

Yes, it is very possible.

Run 'crontab -e' as apropeate user. Your $EDITOR will open.
Write as described in crontab(5) manual ('man 5 crontab'):

0 */4 * * * your_command

This will run your_command every four hours (first field which minutes,
second field in which hours)

You can also edit the /etc/crontab-file (if avaible on your system.) This
file has a different syntax (you specify the user who is going to run the
command too.)

--
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: Ron Thomas
  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: Unix - scheduling

2002-07-02 Thread Michael Cupp
Title: Message



He 
wanted every 4 weeks - 

  
  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 
  11:58 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Unix - scheduling
  Is a strick 14 day rule absolutely necessary, if not...a much 
  more hassle free way would be to simply schedule the 
  cronjob to run on the 1st and 15th of each month, i.e. 
  # Min Hr Day Mon WkDay Command 0 
  0 1,15 * * script 
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling 
  -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 
  -0800 
   0 */4 * * * your_command 
  $ man 5 cronttab; 
   The time and date fields are: 
  
   
  field allowed 
  values  
  - 
  --  
  minute 0-59  
  hour 0-23 
   
  day of month 1-31  
  month 1-12 (or names, 
  see below)  
  day of week 0-7 (0 or 7 is Sun, or use names) 
   A field may be an 
  asterisk (*), which always stands for ``first-last''. 
   Ranges of numbers 
  are allowed. Ranges are two numbers separated with a hyphen. The specified range  is inclusive. For example, 
  8-11 for an ``hours'' entry specifies execution at 
  hours 8, 9, 10 and 11. 
   Lists are 
  allowed. A list is a set of 
  numbers (or ranges) separated by 
  commas. Examples:  ``1,2,5,9'', ``0-4,8-12''. 
  : 
  Question: how does "0 */4 * * *" cause something to run 
  every 4 weeks? Unless your version has a different 
  field order. It might work to try "* */628 * * *" but 
  I'm not sure that cron allows n24 for the hourly 
  divisor. 
  The combination of date and weekday can approximate the 
  4-week cycle. 
  -- Steven 
  Lembark 
  2930 W. Palmer Workhorse 
  Computing 
  Chicago, IL 60647  
  +1 800 762 1582 -- 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). 

This message originated from the internet.  Its originator may not be who they
claim to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.



Re: Unix - scheduling

2002-07-02 Thread alan . aschenbrenner


Aww, come on, crontab -e isn't that bad!  The most dangerous thing
about it is accidentally running crontab -r instead of -e.  Using crontab
-e is no worse than using a wildcard with the rm command,  i.e. 'rm a *'
instead of 'rm a*'.  One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory.  Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems.  If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared.  A few wrong keystrokes in command mode and
you can trash a file real quick

Just my $.02,

Alan

P.S.  I do recommend making a backup of your crontab occasionally
though





   

Jared Still

jkstill@cybco   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
n.com   cc:   

Sent by: Subject: Re: Unix - scheduling

[EMAIL PROTECTED] 

om 

   

   

07/02/02 09:03 

AM 

Please respond 

to ORACLE-L

   

   






Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.

'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.

Jared

On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
  anyone who has a good example on how to write in the crontab if you
want
  to schedule a job to run every four week. Is it possible to do that in
  unix cron job schedule.

 Yes, it is very possible.

 Run 'crontab -e' as apropeate user. Your $EDITOR will open.
 Write as described in crontab(5) manual ('man 5 crontab'):

 0 */4 * * * your_command

 This will run your_command every four hours (first field which minutes,
 second field in which hours)

 You can also edit the /etc/crontab-file (if avaible on your system.) This
 file has a different syntax (you specify the user who is going to run the
 command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  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 the HELP command for other information (like subscribing).



RE: Unix - scheduling

2002-07-02 Thread Michael Cupp
Title: Message



Possible could use at, and have the job re-schedule 
itself for 4 weeks when it first starts - just a thought

  
  -Original Message-From: Richard Huntley 
  [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 
  11:58 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Unix - scheduling
  Is a strick 14 day rule absolutely necessary, if not...a much 
  more hassle free way would be to simply schedule the 
  cronjob to run on the 1st and 15th of each month, i.e. 
  # Min Hr Day Mon WkDay Command 0 
  0 1,15 * * script 
  -Original Message- From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, July 02, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: Unix - scheduling 
  -- Nils Höglund [EMAIL PROTECTED] on 07/02/02 03:28:20 
  -0800 
   0 */4 * * * your_command 
  $ man 5 cronttab; 
   The time and date fields are: 
  
   
  field allowed 
  values  
  - 
  --  
  minute 0-59  
  hour 0-23 
   
  day of month 1-31  
  month 1-12 (or names, 
  see below)  
  day of week 0-7 (0 or 7 is Sun, or use names) 
   A field may be an 
  asterisk (*), which always stands for ``first-last''. 
   Ranges of numbers 
  are allowed. Ranges are two numbers separated with a hyphen. The specified range  is inclusive. For example, 
  8-11 for an ``hours'' entry specifies execution at 
  hours 8, 9, 10 and 11. 
   Lists are 
  allowed. A list is a set of 
  numbers (or ranges) separated by 
  commas. Examples:  ``1,2,5,9'', ``0-4,8-12''. 
  : 
  Question: how does "0 */4 * * *" cause something to run 
  every 4 weeks? Unless your version has a different 
  field order. It might work to try "* */628 * * *" but 
  I'm not sure that cron allows n24 for the hourly 
  divisor. 
  The combination of date and weekday can approximate the 
  4-week cycle. 
  -- Steven 
  Lembark 
  2930 W. Palmer Workhorse 
  Computing 
  Chicago, IL 60647  
  +1 800 762 1582 -- 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). 

This message originated from the internet.  Its originator may not be who they
claim to be and the information contained herein my or may not be Accurate.

All Messages are Scaned to be Virus Free, by IPM, powered by McAfee.



RE: Unix - scheduling

2002-07-02 Thread Sherman, Edward

Roland,

I'm assuming that every 4 weeks means every 28 days which means same day
of the
week (Every 4th Friday for example)

If this meets your requirements then you can try the suggestion at this
link:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1b397b8d1de3d5118ff40090279
cd0f9,00.html

Read A. Clay Stephenson's solution to this.
Click the little paper clip in the top right hand corner of his post.
You will need that attachment to run with your script.

Ed


-Original Message-
Sent: Tuesday, July 02, 2002 4:43 AM
To: Multiple recipients of list ORACLE-L


Hallo,

anyone who has a good example on how to write in the crontab if you want to
schedule a job to run every four week.
Is it possible to do that in unix cron job schedule.

Thanks in advance


Roland

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552 (b) (4) and relevant judicial opinions.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sherman, Edward
  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: Unix - scheduling

2002-07-02 Thread Jared . Still

 If you can't do things carefully, you probably won't
 make it too long as a DBA anyway.

Not using 'crontab -e' *is* being careful.  :)

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: Unix - scheduling



Aww, come on, crontab -e isn't that bad!  The most dangerous thing
about it is accidentally running crontab -r instead of -e.  Using crontab
-e is no worse than using a wildcard with the rm command,  i.e. 'rm a *'
instead of 'rm a*'.  One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory.  Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems.  If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared.  A few wrong keystrokes in command mode and
you can trash a file real quick

Just my $.02,

Alan

P.S.  I do recommend making a backup of your crontab occasionally
though





  
Jared Still  
jkstill@cybco   To: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED] 
n.com   cc:   
Sent by: Subject: Re: Unix - 
scheduling 
[EMAIL PROTECTED]  
om  
  
  
07/02/02 09:03  
AM  
Please respond  
to ORACLE-L  
  
  





Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.

'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.

Jared

On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
  anyone who has a good example on how to write in the crontab if you
want
  to schedule a job to run every four week. Is it possible to do that in
  unix cron job schedule.

 Yes, it is very possible.

 Run 'crontab -e' as apropeate user. Your $EDITOR will open.
 Write as described in crontab(5) manual ('man 5 crontab'):

 0 */4 * * * your_command

 This will run your_command every four hours (first field which minutes,
 second field in which hours)

 You can also edit the /etc/crontab-file (if avaible on your system.) 
This
 file has a different syntax (you specify the user who is going to run 
the
 command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  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 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 the HELP command for other information (like subscribing).



Re: Unix - scheduling

2002-07-02 Thread lembark



-- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800

 
 0 */4 * * * your_command
 
 The */4 must be linux.  This is not available on HP-UX 11.0.

Introduced by Paul Vixie into vixiecron, subsequently adopted
by a number of cron implementations. HP's is, unfortunately,
not one of them. Sun's might, AIX doesn't.

The Schedule::Cron module does support this notation, along
with adding any other extenders you like since you can have
your own dispatcher.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Unix - scheduling

2002-07-02 Thread lembark



-- Hand, Michael T [EMAIL PROTECTED] on 07/02/02 08:13:32 -0800

 Roland,
 crontab alone will not meet your needs.  Hint: check the date command and
 MOD type fuctionality in a shell script.

The at command will normally take number of days from now
as the when to run argument. Simply have the job re-submit
itself and output an error message if at returns non-zero.
This will give you one-minute resolution on the start times
with arbitrary re-run intervals as required for you program
(in this case, 14 or 28 days).

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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: Unix - scheduling

2002-07-02 Thread STEVE OLLIG

not available on Sun (vers 5.8) - just tried it.  nor Digital UNIX.

cool though ;-)

-Original Message-
Sent: Tuesday, July 02, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L




-- Ron Thomas [EMAIL PROTECTED] on 07/02/02 09:03:26 -0800

 
 0 */4 * * * your_command
 
 The */4 must be linux.  This is not available on HP-UX 11.0.

Introduced by Paul Vixie into vixiecron, subsequently adopted
by a number of cron implementations. HP's is, unfortunately,
not one of them. Sun's might, AIX doesn't.

The Schedule::Cron module does support this notation, along
with adding any other extenders you like since you can have
your own dispatcher.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: STEVE OLLIG
  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: Unix - scheduling

2002-07-02 Thread alan . aschenbrenner


Jared,

Point taken.  So I guess I like to live on the edge a little...  :)
I've been using crontab -e for years without problems though.  knock on
wood.

Alan





   

Jared.Still@ra 

disys.comTo: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
Sent by: cc:   

[EMAIL PROTECTED]   Subject: Re: Unix - scheduling

om 

   

   

07/02/02 12:26 

PM 

Please respond 

to ORACLE-L

   

   





 If you can't do things carefully, you probably won't
 make it too long as a DBA anyway.

Not using 'crontab -e' *is* being careful.  :)

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/02/2002 10:14 AM
Please respond to ORACLE-L


To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Unix - scheduling



Aww, come on, crontab -e isn't that bad!  The most dangerous thing
about it is accidentally running crontab -r instead of -e.  Using crontab
-e is no worse than using a wildcard with the rm command,  i.e. 'rm a *'
instead of 'rm a*'.  One deletes all files that start with 'a', the other
deletes a file named 'a' plus everything else in your directory.  Like
anything else, just be careful when you're using crontab and you shouldn't
have any problems.  If you can't do things carefully, you probably won't
make it too long as a DBA anyway.
Although, if you are a vi novice and using it to edit your crontab,
then I would agree with Jared.  A few wrong keystrokes in command mode and
you can trash a file real quick

Just my $.02,

Alan

P.S.  I do recommend making a backup of your crontab occasionally
though






Jared Still
jkstill@cybco   To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
n.com   cc:
Sent by: Subject: Re: Unix -
scheduling
[EMAIL PROTECTED]
om


07/02/02 09:03
AM
Please respond
to ORACLE-L







Please don't use 'crontab -e', unless you are saving your
crontab files and using some form of version control on them.

'crontabe -e' is inherently dangerous, as it is too easy to remove
lines unintentionally, and then they are gone for good.

Jared

On Tuesday 02 July 2002 04:28, Nils Höglund wrote:
  anyone who has a good example on how to write in the crontab if you
want
  to schedule a job to run every four week. Is it possible to do that in
  unix cron job schedule.

 Yes, it is very possible.

 Run 'crontab -e' as apropeate user. Your $EDITOR will open.
 Write as described in crontab(5) manual ('man 5 crontab'):

 0 */4 * * * your_command

 This will run your_command every four hours (first field which minutes,
 second field in which hours)

 You can also edit the /etc/crontab-file (if avaible on your system.)
This
 file has a different syntax (you specify the user who is going to run
the
 command too.)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
  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

Re: Unix - scheduling

2002-07-02 Thread Nils Höglund


 The */4 must be linux.  This is not available on HP-UX 11.0.

It works on BSD-systems too.


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: Unix - scheduling

2002-07-02 Thread Nils Höglund


  The */4 must be linux.  This is not available on HP-UX 11.0.
 
 Introduced by Paul Vixie into vixiecron, subsequently adopted
 by a number of cron implementations. HP's is, unfortunately,
 not one of them. Sun's might, AIX doesn't.

It does not work on Solaris 8.


-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: Unix - scheduling

2002-07-02 Thread Nils Höglund


 He wanted every 4 weeks - 

Whoops! I miss-read.

Thanks for the correction!

-- 
/Nils Höglund, Naqua KB

E-mail: [EMAIL PROTECTED]
Web:http://www.naqua.se/
Home Phone: +46 (0)18  30 09 19
Cellular Phone: +46 (0)709 91 97 65
Address:Nya Valsätrav. 26 B
SE-756 46
Uppsala, Sweden
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?Nils_H=F6glund?=
  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: Unix - scheduling

2002-07-02 Thread lembark


 
 It does not work on Solaris 8.

SunOS (a.k.a. BSD) used vixiecron; they dumped it when
Solaris went SVR4. You can still find workable copies
of Paul's original work (pretty ancient by now). 

Alternative it to use perl with Schedule::Cron to process
the lines. It understands */X notation and passes the entire
line to whatever dispatcher you choose -- which can interpret
the rest of your cron line as whatever it likes.

For example:

* */24 * * * */28 /path/to/code

Would check for the 28th day ever 24 hours :-)

Probably the best bet for something like this is at, however,
since it remembers the date + time that the event was 
scheduled for. This allows re-starting cron any number of
times w/o resetting the start date used by at.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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).