Re: job on timer

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
>
>
>
Received on Sat Jul 10 1999 - 15:30:40 CEST