Solved

Is there any way to insert an event in the crontab, and to cut off that row after that event is fired?

Posted on 2008-10-09
5
302 Views
Last Modified: 2013-12-26
Good morning!

Often, when I have the need to launch a Unix Korn Shell script (which has a duration of about 15 hours), of course I call it from crontab, for example in the crontab file I add the following row:
30 18 * * * $HOME/system/startscript/aggregate.ksh

The risk is that I forget to remove that row after the 18:30 (hour in which the script aggregate.ksh is launched), so that after 24 hours the script will be executed again!

Is there any way to make that row disappear after that the event is fired?
0
Comment
Question by:CRISTIANO_CORRADI
5 Comments
 
LVL 45

Accepted Solution

by:
sunnycoder earned 168 total points
ID: 22676946
Hello CRISTIANO_CORRADI,

you can either add a check in your script to make sure that rerun is intended - e.g. each run creates a file and successive run checks for presence of the file. If file is present, next execution is aborted. For next sucessful cron run you need to remove the file manually.

Other alternative is to remove the cron job after execution

crontab -l | sed '/aggregate.ksh/d' > cron.new
crontab cron.new

you can add the above script as cron job after aggregate.ksh has executed or call it from aggregate.ksh itself

Regards,

sunnycoder
0
 

Assisted Solution

by:vrbiyani
vrbiyani earned 166 total points
ID: 22676977
Crontab itself does not offer a utility to remove the job after it is done. A couple of alternatives (Which again you may be aware of):

1) Specify the date and month also in the job, so that it will be executed only once and not again the next day. Just specifying the time is probably not a very good way to run the job
2) In the script which you are running, add a line to rename/move itself to other location. So that the job running next day does not find it
0
 
LVL 40

Assisted Solution

by:omarfarid
omarfarid earned 166 total points
ID: 22676986
Simple, do it using at command. Please see

man at

http://www.rt.com/man/at.1.html
0
 

Author Comment

by:CRISTIANO_CORRADI
ID: 22677068
All your solutions are very interesting.  Thanks to all, I'll split the points.
0
 

Author Closing Comment

by:CRISTIANO_CORRADI
ID: 31504594
Thank you very much for your interesting suggestions! ;-)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now