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-09 : 10:57:28
|
| Hello I would like to know a script which tells whether the lastnights backup was successful or not and send a mail .Thanks |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-09 : 11:09:12
|
| I think u can use the Enterprise Manager to do this:EM --> UrSvr --> Management --> SQL SvrAgnt --> jobs -->Bringup the properties of the Backup JobLast Tab (Notification)here u goSrinika |
 |
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-08-09 : 11:13:52
|
| I would like to rather have a script which I can execute or schedule it , so that it mails the dba mail box and so that I donot have to regularly go and check in the sql server agent. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-09 : 11:22:04
|
| Yes, the way I suggested is not a script.But, u don't have to check the Server Agent. It can be automated for u to receive the email.[I have never used, but knew that there is such option]Srinika |
|
|
|
|
|
|
script for checking backup