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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-02-26 : 04:18:00
|
| Hello Friends ..Would like have your precious help and advice . I want to automate SQL Mail on all of my SQL Servers . My plan is to have SQL Mail configured on all the SQL Servers and they will send email to one Central SQL Server stating that they are alive and their Email function is working .This Central Server will then collect email notification information from these servers and puts in in a table . The table will be in form of say for e.g Servername Email Fúnction Last Run SQL Server A O.K Date and time SQL Server B Fail Date and time And so on....The Central Server will send this table in a form of email to all SQL administrators in turn . Right now i am getting emails from all the SQL Servers by which my mailbox is getting full unnecessarily everyday . All my SQL Servers are SQL 7.0 with SP 3 . Does anybody has an insight or can share his/her views on this issue ? Any kind of help or information will be of great help to me .Best Regardsadmin001 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-02-26 : 12:22:54
|
| not sure if you are tackling this from the right end....take the case of "Server B" in your example....SQL Server B Fail Date and time how does "Server B" send an email to "Central Server" to say it's "Server B's" email isn't working?...it can't!...these are mutually exclusive situations...if it's working an email gets through, with "a I'm working o.k. message", but if an email doesn't get through, how do you know it's not working and not just very slow?would it not be easier for "Central Server" to actively poll each server and check if it is working, and log same in a log, rather than depend on messages (or in this case the absence of messsages) to deduce a problem exists.try to reverse the control of the problem....and then you may get more accurate information....one way may be to have the central server execute remote SP's which fire off email's back to the central server...logging the start of each process (as a defined "Central Server Request"). then the central server can report on any emails that don't come back within a defined time period...provided the arrival of each email is linked back in sql to a defined "central server request".you may need some automated process of reading emails on the server and converting same into sql (database) information. |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-02-26 : 12:29:07
|
quote:
you may need some automated process of reading emails on the server and converting same into sql (database) information.
You can use the Messaging API to do this, although knowing some VB coding or so is needed.I'll try and dig out the necessary bits if you need them. |
|
|
|
|
|
|
SQL Server 7.0 Email Automation .