July 25, 2008 at 9:17 am
I can send mail by right clicking on Database Mail option on Management and then click on Send Test E-Mail but when I run as a job I get following error.
SUTTER-CHS\_SC_PSQL. SQL Mail does not work with the 64-bit version of SQL Server [SQLSTATE 42000] (Error 17938). The step failed.
July 25, 2008 at 9:44 am
SQL Mail isn't the same as DB Mail, if I remember correctly.
How are the jobs trying to send the e-mail? How were they set up?
- 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
July 25, 2008 at 9:49 am
Job are calling the Stored procedure and inside the stored procedure I am using following command.
DECLARE @EMAIL VARCHAR(600)
SET @EMAIL = 'EXEC master.dbo.xp_sendmail
@recipients = ''' + @RCPT + ''',
@message = ''' + @MSG + ''',
@subject = ''!! LOW FREE DISK SPACE ON ' + @@SERVERNAME + ' !!'''
EXEC (@EMAIL)
July 25, 2008 at 9:55 am
IN 2005 you use sp_send_dbmail as xp_sendmail is how SQL Mail worked which, as the error says, is not supported on 64-bit. Check out sp_send_dbmail in BOL.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 25, 2008 at 11:06 am
It's working when I use SP_send_dbmail instead of xp_sendmail don't know why it's like that but it's working.
Thanks guys.
July 25, 2008 at 3:28 pm
balbirsinghsodhi (7/25/2008)
It's working when I use SP_send_dbmail instead of xp_sendmail don't know why it's like that but it's working.Thanks guys.
xp_sendmail (SQL MAIL) requires an OUTLOOK client. If there is no OUTLOOK client, SQL Mail will fail.
Don't use xp_sendmail any more, db mail is a much better technology.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
July 25, 2008 at 5:23 pm
Thanks Marios.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply