Re: job on timer

Bob wrote:

> Oracle 8.04 running on NT4.
>
> We have a 95 workstation dedicated to this interface. I create the flat
> file, store it on the workstation or a share for the vendor and the vendor
> "dials up" the workstation and scoops up my flat file. I planned to use
> their workstation to do the work since it simply sits there with nothing
> else going on. Right now Ive got a vis basic program running on the 95
> machine that goes out and creates the flat file for me. I still want to use
> Oracle for this because my experience with vb has been that the odbc and ado
> connections are fleeting and sometimes just seem to quit working for no
> reason. This guy needs to just sit there and chug on 24 hrs 7 days forever.
>
> I hoped to find something similar to vis basic's timer.ocx where I could
> create a form with a button to kick off the timer and cause the form to
> execute the script every 10 minutes or so. Oracle has a timer function but
> none of the references to it that I can find show it being used for any such
> project, and like most of the oracle stuff I look up it seems awfully
> convoluted and confusing..:)
>
> dbms_job and some kind of pl/sql script would be great if it didnt impact on
> my server performance. I have to wonder about the resources that would be
> required by utl_file or some of the other oracle routines.
>
> Ari Kukkonen <Ari.Kukkonen_at_kcinet.com> wrote in message
> news:s78336ae.077_at_kcifi1.kci-fi.kcinet.com...
> > I know it's possible, but that's nearly all I know about it.
> > What kind of system do you have, mean the Oracle version and OS?
> >
> > /Ari
> >
> > --
> > Konecranes Components Corporation
> > PC and System Support
> > E-Mail: Ari.Kukkonen_at_kcinet.com
> > Phone: +358 20 427 2232
> > Cellphone: +358 40 747 7537
> >
> >
> > >>> "Bob" <bookor_at_mail.org> 4.7.1999 16:03:25 >>>
> > Message from the Deja.com forum:
> > comp.databases.oracle.tools
> > Your subscription is set to individual email delivery
> >
> > 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
> > 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
> > 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
> >
> >
> >
> >
> >
> >
> >
> > _____________________________________________________________
> > Deja.com: Share what you know. Learn what you don't.
> > http://www.deja.com/
> > * To modify or remove your subscription, go to
> > http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.tools
> > * Read this thread at
> >
> http://www.deja.com/thread/%3C7lnm90%246k4%241%40nntp2.atl.mindspring.net%3E
> >
> >
> >

Look about job_queue.With with you can run pl/sql procedures.

lh Received on Thu Sep 09 1999 - 18:11:21 CEST