Mailsend program

Hi All,

I have installed SQL Server 2005 and created a job. I made the job failed to test the mailsend program. The notification step that uses the mailsend succeeded but I did not get an email. I am using mailsend program on SQL Server 2000 and it works fine. I am really stomped and don't know what to do to fix it?

Thanks.what are you using to send mail? xp_sendmail? xp_smtpmail? CDOSYS? CDONTS?

I feel stomped everyday.|||I am using xp_sendmail.|||have you...

installed outlook on your DB server?

is the agent using a network account mapped to an exhange mail profile?

have you tested sending mail directly from the mail client?

have you started a sql mail client session with xp_startmail?|||Yes, Outlook Express

How can I check it? Our network guys set up the server

Yes and it was successfull

I have read in BOL that this feature will be removed in a future version of Microsoft SQL Server.|||Have you opened the "Surface Area Configuration" tool and looked under feature configuration to enable SQL Mail?

BTW ... Database Mail is the preferred method with 2005.|||I'll try Database Mail option|||Database Mail is MUCH better. It takes a bit of configuration, but it's really nice.

hmscott|||On SQL Server 2005 use sp_senddbmail. It sends mail using SMTP and uses service broker for queuing mails to be sent. No need for Outlook on the server anymore, and the mail sending process is 100% asyncronous.