How to send email notification to user if sql loader fails or success ?

digs developer
digs developer used Ask the Experts™
on
How to send email notification to user if sql loader fails or success ?
After running the control file through sqlldr if it fails then we have send email notification to user.
If it success then also send a email to user for succession.
For this need unix shell script

Please help .
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Given your two open questions on how to decide if it fails, this one is just sending the email.

If you have your server set up correctly, should be a simple mailx.

Something like:
mailx -s "sql loader failed" someuser@mailserver.com << EOF
The message body goes where
EOF

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial