Just use the dbms_job fasility in Oracle.
--
"Rory Tripp" <rtripp_at_xmission.com> wrote in message
news:3b048dff.703030744_at_news...
> It's a long story about why I can't just do that. This machine, due
> to security reasons, sits on a standalone network consisting of only
> an IVR and this box, so the only actual machine we can get reports
> from (which we want to change anyway) is the box that houses Oracle.
> I found some code that I can dump a query to a file using the utl_file
> you suggested, but how do I schedule that to run automatically (i.e.
> what exactly do I have the "AT" job run)? Thanks again for all your
> help.
>
> Rory
>
> On Fri, 18 May 2001 02:20:23 GMT, "Jim Kennedy"
> <kennedy-family_at_home.com> wrote:
>
> >Why can't you just connect to the database with a report writing tool?
(e.g.
> >Crystal reports, Access, et al) If you can issue queries to extract data
to
> >a flat file then it seems to me you could connect via a report writer of
> >some sort. Then you save yourself a lot of extracting the data and
copying
> >it into some other database (it being out of date once you do that - but
in
> >certain situtions that may be fine.) and massaging. Seems like a lot of
> >work.
> >
> >2 ways. Use an NT at job or write an Oracle Job that uses the utl_file
> >interface to write to one or more files. (dbms_job)
> >Jim
> >
> >"Rory Tripp" <rtripp_at_xmission.com> wrote in message
> >news:3b04801c.699475182_at_news...
> >> Sorry for posting a stupid question, but I'm new to Oracle. Our
> >> vendor stores its data in an Oracle 7 database on NT Server 4.0, and
> >> up until now we haven't really been able to get it besides their
> >> canned reports. What I want to do is to schedule a job to
> >> automatically export the previous day's data in the tables. I can
> >> write the SQL statements fine, and I can manually spool it, but how
> >> can I get it to do it automatically each night? Thanks for any help
> >> you have.
> >>
> >>
> >
> >
>
Received on Fri May 18 2001 - 08:40:54 CDT
