Re: Executing a PL/SQL routine at regular intervels....

In article <47repk$t1u_at_sndsu1.sedalia.sinet.slb.com>, ravi_at_toad.NoSubdomain.NoDomain (Ravichandran) writes:
|> Hi Everybody,
|>
|> I started using Oracle recently...
|>
|> I was just wondering if there is anyway to set things up in oracle
|> such that a set of PL/SQL statements are executed at regular
|> time intervels (say once every hour)??
|>
|>
|> Thanks a lot in advance..

Yep. The DBMS_JOB package will do this for you. The tricky bit is that it is beta in 7.2, and won't be production until 7.3

|>
|>
|> Ravi
|>
|>
|> -----
|> E-Mail to: ___-=-___
|> ravichan_at_slb.com ____..---===='===+*+===`====---.._____
|> _____________________ __,-='=====___ ================= _____=====`=
|> (.____________________I__) - _-=_/ `--------=+=-------'
|> / /__...---===='---+---_'
|> '-----'---.___ - _ = _.-'
|> `--------' 713-513-2397.(work)
|> 713-784-7718.(home)
|> Have Fun..
|>
|> Ravi
|> ----------------------------------------------------------------------------
|> Don't confuse fame with success. Madonna is one; Helen Keller is the
|> other. --Erma Bombeck
|> -----------------------------------------------------------------------------
  Received on Thu Nov 09 1995 - 00:00:00 CET