Re: job on timer

Hi Bob,
[Quoted]  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 Mon Jul 05 1999 - 19:38:15 CEST