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 |
|
jsinks
Starting Member
13 Posts |
 Posted - 2007-03-02 : 03:15:03
|
| Can anyone help me!!! Is it possible to write a script to alert me through e-mail that the database back-up has run successfully...The back-up file is served in drive D: each time it runs successfully. |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-02 : 07:49:51
|
| Many different ways this can be accomplished. First is see your other question. I answered it with xp_sendmail. Other method could be to trap the errors and raise an alert. Set the alert to notify the operator on success, failure or completion. Again these will all require that SQLMail be configured properly.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
Successfull Back up alert