Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

send email when there is a new entry in backupset

Posted on 2011-02-16
6
Medium Priority
?
302 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 300 total points
ID: 34912774
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34912923
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
ID: 34912953
what backup software are you using?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Author Comment

by:anushahanna
ID: 34915688
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 1700 total points
ID: 34929392
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
ID: 34935397
thanks rocky!
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
Loops Section Overview

926 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