Re: How to implement Batch Processing in Oracle 7.2 and NT 3.51 using Delphi 2.0

Judy Wong wrote:
> I 'm looking for information/tools for performing batch processing or
> offload some processes to background Oracle server.
> The batch processes are either prescheduled or requested online using
> Delphi 2.0.

There's a useful (though not great) tool built right into the database. It's called the DBMS_JOB package. It works a bit like cron in that it schedules jobs and runs them...either one-shot or repeatedly.  

> The tool may be a JCL-equalivalent and end-users can enquire about the job
> status.

I'd certainly hope it's better than godawful JCL. ;) You'd have to write some wrappers 'round DBMS_JOB but you can check status very easily. Received on Mon Mar 10 1997 - 00:00:00 CST