Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobuddy
Starting Member
2 Posts |
 Posted - 2009-12-28 : 16:50:43
|
| Hello, let me first say I am new to SQL. I am using SQL 2005 on Win Server 2003. I have a maintenance plan setup to backup a db and tlog file. This is working smoothly. I would like to setup a db mail alert for when the backup fails AND another alert for when it is successful. I have database mail setup and actually have alerts setup(and verified to work) for other things like when the db goes above a certain size, however, I cannot figure out how to setup an alert for the backup. The part I'm stuck on is under SQL agent job alert tab, I'm not sure how to set the critera for an alert on completion/fail. Under the "Alert will be rasied on" category, I'm not sure how to set this section up. Any input would be great. Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shobuddy
Starting Member
2 Posts |
Posted - 2009-12-30 : 10:17:41
|
| tkizer, thank you! That is exactly what I needed. I already had an operator setup and it works perfectly! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Alert(DB Mail) for Successful/Failed Backup