Re: How: Loading data automatically

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/11
Message-ID: <567710$m5e_at_newton.pacific.net.sg>#1/1


"Jeremy Wong" <jewong_at_po.pacific.net.sg> wrote:
>I have Oracle running on a Win/NT platform and I need to trigger off a
>data load process automatically every day. I can only think of using an NT
>batch script to run a load program (eg. written using Developer/2000) to
>load the data. And then issue an AT command to run the batch script
>everyday. Anyone with any other way of doing it?
>

Try using DBMS_JOB procedure for running jobs at specified time. This will keep all your automatic jobs within RDBMS. You do not need to rely on OS tools.

Regards

N.Prabhakar
Socgen Crosby Securities,
Singapore Received on Mon Nov 11 1996 - 00:00:00 CET

Original text of this message