Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

send email when there is a new entry in backupset

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
SOLUTION
Avatar of ong-hh
ong-hh

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

ong-hh, we need it run after a backup software run a backup file, not after a job
Avatar of ong-hh
ong-hh

what backup software are you using?
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks rocky!