Funny to ask but anyone has tried to set an alert to notify if SQL Mail is not funtioning? We have hundreds of DTS packages that depend on mail notification and if the mail is not send the job fails. I know there are be third party software that is better than SQL Mail but it's not in our budget and too much work to change the hundreds of DTS packages and PROC. Thanks in advance if have any suggestions.