Re: Oracle/NetWare Batch processes

dcolello_at_oracle.com (David Colello) writes:

>In <32b1tv$ceb_at_felix.dircon.co.uk>, hharriso_at_tdc.dircon.co.uk (Henry Harrison) writes:
>>
>>My two main problems are (a)kicking off the process at the right time,
>>and (b) knowing when all the SQL*Loader processes have finished and I can
>>start manipulating the data.
>>
>>Can anyone tell me any ways of achieving these - and if not in Netware,
>>then any ways of achieving (b) in Oracle?
>>
 

>With Oracle, not really.
 

>However, I've heard alot of good things about a product called Phantom of
> the Console that supposedly can help you set up timed jobs, and do alot
> of the background type of thing you need. Unfortunately, I don't know
> who makes it or any more specifics than that.

   There is a product from the Knowzall Systems, Inc. called    NLM AUTO. It has a "Basic" like macro language you can use    to time the execution of NLM programs on the Netware server.    It can also check error codes and other nice things.

   I can see being able to execute SQL*Loader sessions    and SQL*DBA scripts at particular times and/or    conditionally depending on the success or failure    of a particular script, etc.

   Get in touch with:

         Knozall Systems, Inc.
         375 E. Elliot Rd., #10
         Chandler, AZ  85225
         (800) 333 - 8698

   There is also a company that makes a REXX like language    for NLM manipulation. Not sure of the company though.    Perhaps check out Programmer's Paradise, a mail order co.    They seem to have quite a bit of this stuff.

   Hope that helps.

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Sat Aug 13 1994 - 17:28:21 CEST