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

We are using Oracle 7.1 and we just tried doing the same thing. After we changed INIT.ORA to allow DBMS.JOB to schedule jobs, it created an extra Unix process (one for each job queue), and they used a lot of CPU time (3 min / hr) without a job scheduled. When we scheduled a job (only one) to run once a day, it used up 95% of the CPU time.

The explanation that someone came up with is that it is not supported in 7.1.

We are going to try the "low tech" solution of cron scripts.

Our goal is to capture space and I/O statistics at the end of the day.

Richard

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"
|>
|> Chris
|>
|>

-- 
Richard G. Ramirez, Ph. D.
Assistant Professor of MIS
Iowa State University