Re: job on timer

Ill take a look at that book, should be on Amazon. I had to go ahead and rewrite my interface in Visual Basic to get it done, but I have a couple other projects coming up and will try again.

thanks for the help...

Mark G <someone_at_hot> wrote in message news:3781bbfd.0_at_145.227.194.253...
> Can i recommend Oracle 8 PL/SQL guide by Osbourne Press, it deals with
such
> 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 Wed Jul 07 1999 - 02:19:03 CEST