March 19, 2003 at 9:49 am
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.
March 24, 2003 at 12:00 pm
This was removed by the editor as SPAM
March 24, 2003 at 3:36 pm
I used to have a job in SQL 65 that run xp_startmail periodically. That covered most bases, but it also sent an alert via an smtp client if the message ever said "sql mail started" rather than "sql mail is already running"
Steve Jones
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply