Re: dbms_jobs versus cron

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 8 Jan 2003 13:04:43 +0100
Message-ID: <avh46j$fefra$1@ID-152732.news.dfncis.de>

Hi, Hanne,

I do not have that much experience, but afaik there are some common errors I made too in the first place:

• in order to make jobs able to run at all; otherwise nothing will happen ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 1; --creates a permanently active USER session with event 'rdbms ipc message'

-->stop all jobs:
ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 0; --set job specs ... ok
DECLARE
   jobno number;
BEGIN
   DBMS_JOB.SUBMIT(jobno,

       'itsme.jg_load_objects;', --calling a stored proc. ***never miss the ";" in it ***

       SYSDATE,
       'SYSDATE + 1/48' --every half hour

    );
END;
/
--and the user of the job should be the user that own the Stored Procedure, also

That was it.
It then ran fine 700 times, no single error, until I stopped the job normally.

My system:
Oracle EE 8.1.7.3 on AIX 4.3.3

Hope it helps ...
Jan

"Hanne Iren Midttun" <hannem_at_tihlde.org> schrieb im Newsbeitrag news:Pine.LNX.4.21.0301080901580.19558-100000_at_colargol.tihlde.org...
> Hi,
> from another thread (Oracle stored procedures vs Running from a flat .sql
> file), I saw that it was stated that dbms_jobs was better then cron.

>

> I have only runned dbms_jobs on 7.3.4 AIX (I think it was the right
> version, it's been a while), and on that version cron was far better.
> (ie the dbms_jobs did not run at all and so on)
> I was really sorry to migrate to cron because moving a database from one
> machine to another was really a lot of work - I allways forgot a script, a
> directory, some rights on the filesystem and so on.

>

> Now I am running 8.1.7.4, AIX and thinking of migrating to 9i. does
> somebody have any experience with dbms_jobs on this versions?

>

> regards Hanne

> Received on Wed Jan 08 2003 - 06:04:43 CST