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 |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2003-10-23 : 16:27:03
|
| I want to be able to send mail from my SQL server 7.0 . I do not want to install OUTLOOK or any other program if it is not necessary. How do I achieve this? I primarily want to use it for mailing alerts if the jobs fail.All help is appriciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-23 : 16:48:19
|
| [url]http://www.sqlteam.com/item.asp?ItemID=5908[/url]If you want to use job notifications though, you'll need to use SQL Mail which requires an e-mail client. You could check msdb.dbo.sysjobs for job failures though and write your own job notification system.Why don't you want to install Outlook on the server? We've got it on all of our production SQL Servers and it has not caused any problems.Tara |
 |
|
|
|
|
|
Sending mail from SQL Server