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

Try setting up a cron job that uses a script file with something like this:

...
sqlplus user/passwd <<EOF
[ PL/SQL statements]
...
EOF Cheers,
Chuck Chan, cchan_at_oacis.com 415.898.4032(Home) 415.925.4491(Work)

Ravichandran (ravi_at_toad.NoSubdomain.NoDomain) wrote:
: 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..
Received on Thu Nov 09 1995 - 00:00:00 CET