SQL 2005 Email Job Completion Reports

Posted on 2008-11-06
Last Modified: 2012-05-05
I'm setting up a Maintenance Plan in SQL 2005. It is a simple plan to just backup sql databases. After the JOB is done, I want it to email me with a report of the summary whether it's failed or succeeded.

How do I go about doing that?

I was able to setup an SQL Operator, and use the NOtifiy Operator Task at the end but that just seems to be a way to email a person with a generic text that I define and not the actual summary report
Question by:trcadmin
    LVL 19

    Accepted Solution

    You could configure additional steps, one for success notification, another for failure. In this step, you will send email by using dbo.sp_send_dbmail stored procedure.

    Check this link for additional information:

    Author Comment

    so i'm guessing there's no check box button for this. I gotta write up a query?
    LVL 19

    Expert Comment

    I think so.
    LVL 19

    Expert Comment

    BTW, just encountered this link. I think it could be useful to you.

    Script to send an email based on contents of a job step's output file


    Author Closing Comment

    We used this as a springboard for writing our own query

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    746 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

    17 Experts available now in Live!

    Get 1:1 Help Now