Re: Automatically running SQL Loader

From: Spencer <spencerp_at_swbell.net>
Date: Tue, 30 Jan 2001 23:40:43 -0600
Message-ID: <kzNd6.524$nD1.9861@nnrp1.sbc.net>

use cron to schedule a shell script that tests the existence of the certain file, and executes SQL Loader if it is found.

we had a setup like this running for several years with 7.x. since the file was being ftp'd to the box, we did have to add additional checks to ensure that we had the whole file, and not just part of it.

"Chris" <sr_developer_at_my-deja.com> wrote in message news:94l02n$m1t$1_at_nnrp1.deja.com...
> After I create a load file to use with SQL Loader, is there a way to
> automate the execution of SQL Loader, to schedule it perhaps, or make
> it run when a certain file is present?
>
> Thanks
> Chris
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 30 2001 - 23:40:43 CST