Re: job on timer

Ill have to take a look at that, is the location the same on NT and Unix installs? By code that defines them, do you mean they are written in pl/sql and the source is there to see?

Im gradually finding out about these packages, but its not been easy. I really appreciate the assistance Ive been able to get from other developers, been tough getting good info on Oracle from Oracle or any of the normal docs Ive been able to scrounge up..

thanks again

Graham Miller <lgmiller_at_elmrd.u-net.com> wrote in message news:3780eae5.2443834_at_news.u-net.com...
> Hi Bob,
> To find out more about the various DBMS_* packages it is worthwhile
> having look at the code which defines them. They are very well
> commented, including examples of use!
>
> You will find the source code in the 'admin' directory under
> 'oracle_home'. All the files have names starting 'dbms'.
>
> The common ones to look at are: dbmsPipe, dbmsJob, dbmsAlert and
> dbmsLock.
>
> dbmsJob will 'only' run PL/SQL code. You need to change a couple of
> the database 'init' parameters to provide processes to run the jobs.
>
> It is an excellent facility as Oracle automatically re-starts the job
> queue when it comes up. I use it to run a 'listener' for error message
> reporting which sits on the end of a pipe and writes error messages
> from any PL/SQL client to an error messages table. It runs as a
> 'dbms_job' and is always available.
>
> One book which explains some of this nonsense is 'Oracle PL/SQL
> programming' by Oracle Press.
>
> graham
>
> On Sun, 4 Jul 1999 17:13:14 -0400, "Bob" <bookor_at_mail.org> wrote:
>
> >Thanks for the reply. It's amazing. I've researched this simple project
in
> >all the Oracle manuals as well as several third party books and it is
> >unbelievable how little information they really provide. I read several
> >sections about utl_file and text_io and the only simplistic description I
> >got was utl_file was a server application and text_io was a client
> >application. So I spent days working on this routine because I want it to
> >run on the client without impacting the server any more than possible.
Now
> >I find Ive been on the wrong track all along. Guess I start over again.
> >
> >Im still confused about the dbms_job however.
> >
> >The select statement will give me a list of dbms_jobs I think, but how do
I
> >submit a job. From svrmgr80, from sqlplus, I feel stupid because I
should
> >be able to look it up, but I swear there are no instructions in the
manuals
> >just a description of what the dbms_job does. No real help on the
specifics
> >of "type this in at this prompt to accomplish this" .
> >
> >
> >Thanks for the reply. It has be unbelievably hard to get any useful help
> >with Oracle, nothing at all like any other applications Ive ever had to
> >learn.
> >
> >bookor_at_interserv.com
> >
> >
>
Received on Tue Jul 06 1999 - 02:25:51 CEST