Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to check if my DB mails are running? Expand / Collapse
Author
Message
Posted Monday, June 13, 2011 5:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 11:09 PM
Points: 10, Visits: 51
Hello all,

Greetings!

I have a situation eating my head! We have around 6-7 servers of 2005 and 2008 version and I am expected to check if the emails are running fine on all of them.

The problem here is, in most of the databases the SMTP settings are stored in some table and XP_SMTP_SENDMAIL procedure is used to fire mails using the details. While with some latest databases I have SP_SEND_DBMAIL procedure used (i.e. I have profile created on the server).

The SMTP settings are allowed to change from the application, which can cause the mails to go down.

What I have thought of is, using linked servers to fetch all SMTP data to send mails. But in this case I have to use XP_SMTP_SENDMAIL procedure, which I don't want to considering the advantages of SP_SEND_DBMAIL.

What could be best possible solution for this?

Many Thanks in advance.

Regards,

Shardul.
Post #1124178
Posted Monday, June 13, 2011 6:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
If you're using DBMail (sp_send_DBMail), then all the e-mails are queued and logged in msdb, and you can query the relevant tables for status, etc., pretty easily. That's what I do to check on that.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1124229
Posted Monday, June 13, 2011 8:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 11:09 PM
Points: 10, Visits: 51
Thanks for that. Ya, msdb sysmail tables are on the options, but my main target is to get identified first if mails on some db is down. I think I may have to send periodic mails say every week can do the job.
Post #1124315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse