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 |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-03-28 : 05:45:26
|
| It seems that in order to get an email alert from SQL Server 2000 I need Microsoft Outlook orMicrosoft Exchange client installed. Is there any other way to get an email alert (not net send) when a back up is finished? for example using a @hotmail.com account?thanks |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-03-28 : 08:45:21
|
| I believe you can create a new mail account from control panel->email and use that though I have not tried using other mails.Prakash.PThe secret to creativity is knowing how to hide your sources! |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-03-28 : 09:08:56
|
| Have you tried xp_sendmail anything like that |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-29 : 00:46:17
|
| Sql2k agent supports pop3 only. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-29 : 07:10:41
|
| Elidas , are you managing the backup through a stored procedure and set as a job or are you using another way of triggering the backup, such as a third party storage manager?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
Elidas
Starting Member
33 Posts |
Posted - 2008-03-31 : 05:14:24
|
| ok thanks, now I can send an email alert using the SMTP server when the back up is finished |
|
|
|
|
|
|
Email alert in SQL Server 2000