HI mrt1
You can do following..

Create a shell script, in which store control,log and bad file locations in a host variables, say cfile,lfile and bfile respectively.By using UNIX shell syntax , check all files/path exist.If everything is fine then execute sqlloader as below...

sqlldr userid/passwd control=$cfile/ctl_file.ctl log=$lfile/logfile.log bad=$bfile/bad_file.bad

Include this in shell script.

good luck.

kp397

Below is a short  and simple one.  [Assume $1->controlfile,$2->logfile, $3->badfile,
userid=scott/tiger, and the email address to be notified is abc@xyz]
-------------------------------------------------------------------------------------------

#!/bin/sh

if [ $# -ne 3 ]; then
echo "Usage: $0 controlfile logfile badfile"
exit
fi

sqlldr scott/tiger control=$1 log=$2 bad=$3 #[,keyword=value,...]

if [ `cat $3 | wc -l` -gt 0 ]; then
mailx -s "SQL*LOADER badfile" abc@xyz < $3
fi

You can use the command-line options:

sqlldr scott/tiger control=emp.ctl data=emp.dat

The data option is overwriting our "INFILE" section in the control-file !

To check your result, use i.e. "grep","sed","awk" from the commandline to check your log-file.

You could also check for existence of bad file by

if [ `ls -ltr bad | wc -l` -ne 0 ]
 echo " bad file exists " >> call_loader.log
fi

Yuck....it shud have been  somethin like *.bad instead of bad.