SQL Server Performance Forum – Threads Archive

SQL Mail Alternatives…

what other options does one have if
you can’t use SQL Mail cause mail clients
are restricted from existing on servers? in other words… if you can’t use the usual
SQL mail… what can you use for mail alerts? thoughts? – SQL.Admin – US.Florida

http://www.sqlteam.com/filtertopics.asp?topicID=125 See if these articles help you. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Hi, You can try using CDO in sql server. Check this link
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech Hope it helps. Regards
Sachin

these are interesting work arounds to the conventional mail,
but from what i’ve been reading none of this can actually be
used from a ‘job’ perspective. what i mean is… this isn’t usually performed from selecting
an operator form notification tab. is there a way that you can trick the operating system into
believing it has a mapi mail client. thoughts? – SQL.Admin – US.Florida

Have you tried this?http://www.sqldev.net/xp/xpsmtp.htm —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

If the corporate policy is not to allow servers to generate mail then I’d suggest either using the event logs (you do have a enterprise management solution for event logs right? <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> ) <br />All though this is a pain you don’t really want your mail servers configured to accept SMTP traffic based on the IP of your SQL server.<br /><br />Configure alerts to page whoever wrote the policy.

SQLAgentMail can also stop responding when invoked from a scheduled job in SQL Agent.
If the connection to the mail server stops responding, for whatever reason, then the job scheduler that issued the command to send mail stops responding and no other scheduled jobs can run until the problem is corrected and the SQL Server Agent is stopped and restarted. Use the process referred by Frank, which is a good one with less hassle.
http://www.sqlteam.com/item.asp?ItemID=5908 for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>