Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2005 Email Job Completion Reports

Posted on 2008-11-06
5
Medium Priority
?
727 Views
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
0
Comment
Question by:trcadmin
  • 3
  • 2
5 Comments
 
LVL 19

Accepted Solution

by:
Rimvis earned 2000 total points
ID: 22903254
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:
http://articles.techrepublic.com.com/5100-10878_11-6164310.html
0
 

Author Comment

by:trcadmin
ID: 22926002
so i'm guessing there's no check box button for this. I gotta write up a query?
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 22928723
I think so.
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 22929233
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
http://www.sqlservercentral.com/scripts/Email/64272/

0
 

Author Closing Comment

by:trcadmin
ID: 31514155
We used this as a springboard for writing our own query
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

578 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