Jeff, Basically it should check the log file for any errors and send email to our group showing error(s) if any exist. Thanks & Regards Noor M From: ~Jeff~ [mailto:jifjif@xxxxxxxxx] Sent: Monday, December 14, 2009 1:52 PM To: Noor Mulla; Oracle-L@xxxxxxxxxxxxx Subject: Re: sqlldr depending on the shell etc, it'd be something like: [ -f somefile.bad ] && mailx -s 'some subject' recipient@xxxxxxxxxxxxxx<mailto:recipient@xxxxxxxxxxxxxx> < somefile.log hope that helps... Jeff 2009/12/14 Noor Mulla <Noor.Mulla@xxxxxx<mailto:Noor.Mulla@xxxxxx>> Below(trailing mail) was the question? We want to make changes to the programs responsible for creating the oracle load script and control files Incorporating monitoring of our SQLLDR jobs into our migration programs(checking load errors) Example: sqlldr DATACITI_MDE/today05@GERD_UAT_NJ7 control=Oracle/dbo_DATACITI_MDE.trans_acknowledgeme nt.ctl direct=true columnarrayrows=10000 readsize=104857600 log=log/dbo_DATACITI_MDE.trans_ac knowledgement.log bad=log/dbo_DATACITI_MDE.trans_acknowledgement.bad discard=log/dbo_DATACITI _MDE.trans_acknowledgement.dis After [adding a line after each sqlldr invocation] sqlldr DATACITI_MDE/today05@GERD_UAT_NJ7 control=Oracle/dbo_DATACITI_MDE.trans_acknowledgeme nt.ctl direct=true columnarrayrows=10000 readsize=104857600 log=log/dbo_DATACITI_MDE.trans_ac knowledgement.log bad=log/dbo_DATACITI_MDE.trans_acknowledgement.bad discard=log/dbo_DATACITI _MDE.trans_acknowledgement.dis #check for existence of bad file. if it exists, send email with log file attached Thanks & Regards Noor DISCLAIMER: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. -----------------------------------------------------------------------------------------------------------------------