Re: Job-Schedueling in ORACLE

From: Pascal Glauser <glauser_at_my-deja.com>
Date: Sat, 12 Feb 2000 22:55:22 GMT
Message-ID: <884ocq$nh9$1@nnrp1.deja.com>

Hi Wolfgang

Take a look at the dbms_job package in schema sys. It lets you scedule jobs right in the rdbms, so no need to launch the job from outside the database (as does EM, I guess). My tip: You have to commit your changes after a call to dbms_job.

HTH
Pascal Glauser

In article <38a57408_at_alijku02.edvz.uni-linz.ac.at>, "wolfgang karrer" <wolfgang.karrer_at_ce.uni-linz.ac.at> wrote:
> Hi, im a newbiiiiiii!
>
> i want to start a job, who updates records in two tables - the
> sql-statement isn't a problem, but creating the jobs in the oracle
> enterprise edition 8.0.5 is not very easy.
>
> Every time i konfigure a job, the enterprise manager hangs up. i've
tried
> this action on another server with the same enterprise edition, but
the
> problem is the same.
>
> Could anyone give me a hint how to configure a job and how to start
them???
>
> Is it possible to start a job from the command line. and which
parameter
> must i use.
>
> thx a lot
>
> --
> Wolfgang Karrer
> Büro für EDV-Dienstleistungen
> Gewerbegasse 6
> 4060 Leonding
> Tel + Fax. (0732) 681795
> Mobil: (0699) 134 18 469
> EMail: w.karrer_at_ooenet.at
> ---------------------------------------
> Institut für Wirtschaftsinformatik
> Abteilung Communications Engineering
> o.Univ.- Prof. DI Dr. Christian Stary
> Freistädterstr. 315
> 4040 Linz/Urfahr
> Tel: (0732) 2468-7104
> EMail: wolfgang.karrer_at_ce.uni-linz.ac.at
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 12 2000 - 16:55:22 CST