how to send automatic EMail from SQL or SAP B1

[Former Member]

hi experts as we are using SQL as DB i ned to send E-mails from sap system automatically but from SBO mailer  or Scheduler is not working from my side now i was planning to send emails from SQL can any one help me how to send emails automatically from SAP business one or from SQL

[Former Member]

http://stackoverflow.com/questions/13300881/how-to-send-email-from-sql-server

Cheers

[kothandaraman_nagarajan]

Hi,

Please raise ticket to SAP support. As discussed earlier its working for 8.82 PL04 version.

Thanks & Regards,

Nagarajan

[LukaszBloch]

Hi

In SQL under Management\Database Mail

You can configure account you use to send mails from SQL

Then you can prepare procedure that will send mail

for example

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Hurtpol',

@recipients = 'lukasz.bloch@altab.pl',

@query = 'select isnull(syncherror,'''')  collate polish_ci_as

from np.dbo.OITM

where U_SynchStatus=''Failed''',

--@body = @tresc,

@subject = 'synch error'

read about sp_send_dbmail