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

Posted on 2014-08-11
Last Modified: 2014-08-18
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 .
Question by:digs developer
    1 Comment
    LVL 76

    Accepted Solution

    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" << EOF
    The message body goes where

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
    About FreeBSD Jails In FreeBSD, jails are a way of doing operating system level virtualization.  The basis of FreeBSD jails is chroot (, which changes the root directory of processes.  As a…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now