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 |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-02-16 : 17:50:57
|
| Guys,I have SQL Server 2000 installed on a server where, for security purposes, mail server was not installed. I have looked for ways to set up different alerting mechanisms (e.g. upon a job failure, send an email), but the lack of the mail server created a problem.Recently, I found an article describing how to send emails from the SQL Server even with no mail server installed (http://www.sqlteam.com/item.asp?ItemID=5003). I tried it. And altough the stored procedure compiled and executed with no problems, no email message has been sent. I still cannot figure out why.Today I learned that we can use 'NET SEND' to achieve at least partially what I wanted. Namely, I can set up the operator and have a job be binded to the operator, so that if a job fails, a pop-up message comes up. Although it is a work-around, it is not the best one, as I do not know how to get those messages on my blackberry (which I could, would I have the ability to send emails).Questions:1. Does anyone know any other working way of sending email alerts when no email server is installed?2. Does anyone know whether it is possible to somehow capture net-send message and fire up an email?Any suggestion is greatly appreciated!Thanks |
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-02-16 : 18:19:25
|
| i am using System.Net.Mail in .NET. i created a database with a stored proc that inserts emails after a job failure. In jobs --> Steps i added a step on failure that does the insert. Then the .NET app checks every 5 mins for unsent emails, the .NET app is a windows service. This is complicated but really works well. We have 22 SQL boxes and all boex point to the same stored proc.This also creates a history i can monitor.Jay |
 |
|
|
|
|
|
|
|
Alerts, Emails, Net Send