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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2006-08-28 : 12:53:11
|
| Hellocan I get a script that sends a mail to the dba mail box using the SMTP server when the database backup fails.I have not been using the sqlmail , or the sqlserver agent for my other jobs to report. ThanksDushyanth |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-08-28 : 13:00:17
|
| I would think you could write an app to pole the success of the jobthat runs the backup and use Jmail or something. (msdb db... sysjobs tables)or setup sqlmail (or if you have sql2005 smtp)or use a product like SQLSentry________________________________________________"Wow, you have a master's degree in psychology? I will order a vodka martini, thanks" |
 |
|
|
|
|
|
Script to get mail when database backup fails