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

In article <47ti6m$rnb_at_news.corpcomm.net>, kasten_at_brookings.net (Chris Kasten) writes:
|> 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"

If you do this, make sure to set the environment variables necessary to run Oracle (ORACLE_HOME, ORACLE_SID, etc.) in the script before the sqlplus call. cron doesn't run your .cshrc or .login files automaticly.

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