I agree with Jan. I have been using it for many years since 7.1. Never had
a problem. The nice thing is that it works no matter what OS Oracle is on.
Same code works for Oracle on NT, Solaris, HPUX, AIX etc.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:avh46j$fefra$1_at_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 - 07:12:34 CST
