Re: Report Scheduler (Unix) Ideas?
Date: Fri, 17 Sep 1999 08:50:38 +0200
Message-ID: <37E1E4BE.2DF4FAE3_at_tue.nl>
Jenny,
We are in the process of migrating from forms, sqlplus and report
applications on a Alpha OpenVMS to an application server (Sun Solaris).
We had many batch programma's on the alpha which needed to be converted
to a three tier environment. I had to change a lot of host('submit ...')
statements in our forms app's to custom build solution. I use an Oracle
table to hold requests. A cron job looks at the Oracle table every 10
min. to see if there are jobs waiting .
All 'host(submit...)' statements where replaced by a custom built pl/sql
procedure. All our OpenVMS DCL scripts were replaced by Unix scripts.
If you want more details let me know.
Jenny Farnham wrote:
> I'm interrested hearing how folks schedule reports
> from a Forms 4.5 (or whatever version) so that the
> more than one report can run at a time. Do you use
> the cron utility? Did you write something custom?
>
> So, imagine a menu of reports running in Forms 4.5 on
> a Unix system. When the users goto run these reports
> (in the background - not at their screen)... how
> do you handle it?
>
> Shell scripts? Tables to hold requests?
>
> Thanks for any ideas, experiences you can share
Received on Fri Sep 17 1999 - 08:50:38 CEST