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

surman_at_oracle.com (Scott Urman) wrote:

> 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

Another low-tech option would be cron scripts that run when you tell them to. In the script you'd call

   "sqlplus name/password script.sql"

Chris Received on Thu Nov 09 1995 - 00:00:00 CET