Re: How do I batch?

In article <47uobr$l5i_at_fountain.mindlink.net>

           mcdoo_at_worldgate.edmonton.ab.ca "Keith Thompson" writes:

Keith,

Thanks for the pointer to DBMS_JOB - I'll have a play with that!

Andy
> X-Mailer: Mozilla 1.1 (Windows; U; 16bit)
>
> Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:
> >
> >Is there a facility that will allow me to submit jobs to the database -
> >to be executed when it has time?
> >
> >Oracle 7.1.4 and 7.1.6.
> >
> Although not strictly a batch queue facility, you may want to
> check this out:
>
> In Oracle 7.2, there will be a facility called DBMS_JOB, which will
> allow scheduling of PL/SQL jobs within the database, much like
> cron does in Unix.
>
> Apparently, DBMS_JOB is included in 7.1, but is not supported. If
> you want to give it a go, poke around in
> $ORACLE_HOME/rdbms/admin/dbmsjob.sql.
>
> I have not tried it myself yet, and don't bother calling tech support
> if it doesn't work, but you may find what you are looking for.
>
> Hope this helps.
>
> Keith Thompson
> Working, but not speaking for, Sierra Systems Consultants Inc.
> Edmonton, Alberta, Canada
>
>
 

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
Q:      How many Martians does it take to screw in a lightbulb?
A:      One and a half.