Re: job on timer

[Quoted] Can i recommend Oracle 8 PL/SQL guide by Osbourne Press, it deals with such [Quoted] issues, dbms_sql, utl_file etc. The syntax of utl_file is similar to text_io, which you should find in forms help.

Mark

Bob wrote in message <7loivl$jk0$1_at_nntp1.atl.mindspring.net>...
>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
>
>
>
>
>Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
>news:37816380.2968338_at_newshost.us.oracle.com...
>> A copy of this was sent to "Bob" <bookor_at_mail.org>
>> (if that email address didn't require changing)
>> On Sun, 4 Jul 1999 09:03:25 -0400, you wrote:
>>
>> >Im sure this is a simple question, but Im new to Oracle. I need to run
a
>> >sql script on a timer. Say once every half hour to extract data
matching
>a
>> >certain criteria to a fixed length text file. I have the script
>running ---
>> >but only from a button on a form. Can I create a timer on the form that
>> >will submit the job? Ive read about dbms_job to submit jobs but I can
>not
>> >find any documentation that explains how to use it. I also cant get my
>plsql
>>
>> its in the application developers guide but the query:
>>
>> select text from all_source where name = 'DBMS_JOB' and type = 'PACKAGE'
>order
>> by line;
>>
>> will get it as well.
>>
>> >script to run in sqlplus. For some reason it will only run from the
form
>> >4.5 form. Does anyone have any simple method I can use to get this job
>>
>> you are probably using TEXT_IO to create the file. text_io is forms
>specific.
>> See UTL_FILE in the application developers for the API that does server
>side
>> file IO (you need 7.3 or up for that).
>>
>>
>> >done? Timer on a form or modify the plsql so it will run from sqlplus
>and
>> >use dbms_job?
>> >
>> >any help would be appreciated...
>> >
>> >bookor_at_interserv.com
>> >
>> >
>> >
>>
>>
>> --
>> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to
>Oracle8i'...
>> Current article is "Part I of V, Autonomous Transactions" updated June
>21'st
>>
>> Thomas Kyte tkyte_at_us.oracle.com
>> Oracle Service Industries Reston, VA USA
>>
>> Opinions are mine and do not necessarily reflect those of Oracle
>Corporation
>
>
Received on Tue Jul 06 1999 - 10:29:24 CEST