SQL Backup Report Email

SQL 2008

I am trying to set up a report to be emailed to me once an SQL backup job has been completed.

I have configured a database mail, which sends me a blank email once it has finished, idealy I would get a fail or success email.
LVL 3
Bransby-ITAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
set the sql agent job notification "when job completes"

How to setup SQL Server alerts and email operator notifications
http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/
0
 
Jared_SCommented:
Why not use the built in notifications to email yourself if the job fails?
0
 
Bransby-ITAuthor Commented:
Thanks team but I cant actualy see any auto to give me the backup job, any errors on backing up?
0
 
Eugene ZCommented:
Bransby-IT: please clarify your last post
0
 
Bransby-ITAuthor Commented:
EugeneZ I have no idea what I was trying to say. Your last comment was on the mark.

Thanks
0
All Courses

From novice to tech pro — start learning today.