RE: DBMS Job vs C Daemon

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 15 Mar 2002 07:23:44 -0800
Message-ID: <F001.0042AA14.20020315072344@fatcity.com>

We don't let developers run the job .... but your idea is good about semaphore ....

Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Friday, March 15, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L

I also agree, cron WORKS well ! The only thing I would add to cron jobs
(shell scripts) is to use a semaphore file.

e..g.

¯---------------------------------------

semfile=/tmp/$0.RUNNING

if [ -f $semfile ] ; then exit ; fi
touch $semfile

DO SOME SHELL STUFF rm $semfile
exit

¯---------------------------------------

This way no matter how frequent you run the job or how long it takes the job to run, it still works. I had a developer run a job every 5 mins but the job took 15 mins to run, so you can guess what begins to happen after a few days :-)

Gene

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

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: ListGuru_at_fatcity.com (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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Mar 15 2002 - 09:23:44 CST