Solved

send email when there is a new entry in backupset

Posted on 2011-02-16
6
246 Views
Last Modified: 2012-05-11
how can you setup a job to send an email out when there is a new entry in backupset for a particular database and type = 'd' only

thanks
0
Comment
Question by:anushahanna
  • 3
  • 2
6 Comments
 
LVL 4

Assisted Solution

by:ong-hh
ong-hh earned 75 total points
Comment Utility
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
ong-hh, we need it run after a backup software run a backup file, not after a job
0
 
LVL 4

Expert Comment

by:ong-hh
Comment Utility
what backup software are you using?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 6

Author Comment

by:anushahanna
Comment Utility
it does not matter which one- it could be sql 2008 r2 or legato- regardless there will an entry in backupset... and if there is one for
select count(*) from msdb..backupset where database_name = 'tracker' and type='d'
then we need to send an email.
0
 
LVL 4

Accepted Solution

by:
rocky_lotus_newbie earned 425 total points
Comment Utility
You can create an insert trigger on the backupset table to send an email to you using Database Mail, whenever a record of type D for a particular database is inserted.
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
thanks rocky!
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

8 Experts available now in Live!

Get 1:1 Help Now