Re: job on timer

From: Ari Kukkonen <Ari.Kukkonen_at_kcinet.com>
Date: Wed, 07 Jul 1999 11:14:43 +0300
Message-ID: <s78336ae.077_at_kcifi1.kci-fi.kcinet.com>

[Quoted] 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
[Quoted] certain criteria to a fixed length text file.  I have the script running ---
[Quoted] 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
[Quoted] 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 Wed Jul 07 1999 - 10:14:43 CEST