Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time based triggers?

Re: Time based triggers?

From: Andy Hardy <aph_at_glink.net.hk>
Date: 18 Apr 1998 14:08:55 GMT
Message-ID: <01bd616e$7b15e050$0101010a@goldcoast1>


Have a look at the dbms_job package - a sort of crontab within the database.

Andy

rtgraf_at_sintec.de wrote in article <6g2hg0$fnc$1_at_nnrp1.dejanews.com>...
> In article <6fspcn$ijo$1_at_juliana.sprynet.com>,
> "S Green" <twogreens_at_sprynet.com> wrote:
> >
> > I want to schedule PL/SQL modules to run periodically. Can this be
done via
> > a trigger? What other options exist. I suppose that I could call the
> > routines from a cron job, but this does not seem very elagant.
> >
> > TIA
> >
> > Scott Green
> > twogreens_at_sprynet.com
> >
> >
> Sorry, bad luck. No better solution from SINTEC... Use your cron job.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Sat Apr 18 1998 - 09:08:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US