Re: Starting a job from NT 4.0 Form 5.0 on to another UNIX database server

Robert Jones wrote in message <36f81d48.2279237_at_news.demon.co.uk>...
>Hi,
>
>We have our own job server which does this - runs in shell on Unix and
>Tcl on NT. When a user submits a job we write a record to a table. A
>server program then reads this table at regular intervals and kicks
>off the jobs. You can also use PIPES to do this - there are numerous
>examples in Oracle books - PL/SQL Programming gude.
>
>
>On Thu, 18 Mar 1999 16:36:21 GMT, "Suresh Bhat"
><oracleguru_at_mailcity.com> wrote:
>
>>Hi -
>>
>>We are about to start converting our SQL*Forms 3.0 forms on SUN UNIX to
>>Developer/2000, Oracle forms 5.0.
>>
>>Our main database instance is on UNIX server.
>>
>>In SQL*Forms which are on UNIX server we start many of our SQL*Plus
>>scripts, Fortran programs, Bourne shells etc. by using the HOST command
>>such as:
>>
>> DEFINE TRIGGER
>>
>> NAME = key-print
>> TRIGGER_TYPE = V3
>> DESCRIPTION = PRINT HISTORY REPORT
>> TEXT = <<<
>> if :stationbus.meter_id is not null then
>> message('Analysis History Report for Station
>>'||:stationbus.station ||
>> ' is being sent to your printer.'); bell; pause;
>> :global.var := 'nohup sqlplus -s / _at_$ORF_EXE/anahist '||
>> to_char(:stationbus.meter_id) || ' ' ||
>> to_char(:b1.ndb_sample);
>> host (:global.var ||' > /dev/null &', no_screen);
>> else
>> message('Please Query the Station prior to requesting the
>>Report.');
>> bell;
>> end if;
>> >>>
>>
>> ENDDEFINE TRIGGER
>>
>>or
>>
>>host ('$ORF_SRC/run_report.sh '||:BAT.BAT||' &');
>>
>>etc.
>>
>>I feel it is possible to send a job request to UNIX server from NT via
>>Oracle form 5.0.
>>
>>Which is the best and easiest way ?
>>
>> dbms_pipe/dbms_alert
>>
>> dbms_job sent to the server for execution on the server
>>
>> rsh from NT form 5.0 to UNIX ( Is it possible? )
>>
>> FTP a shell script to the server and have a daemon/cron look for it and
>>run it ?
>>
>>Any other ideas? details? examples? suggestions? all are welcome.
>>
>>Thank you.
>>
>>
>>Suresh
>>
>

And if your database is Oracle8 you can use "external procedures".

Finn Received on Sun Mar 28 1999 - 13:50:32 CEST