• There are two approach:

    one is you can use notification feature of the job to send e-mail notification when job completes i.e. success or failure.

    Second is you periodically check the job history table in MSDB database to send result via e-mail attachment.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."