Sending mails from Engine V11 using standard procedure in SQL

Hi, we'd like to send mails from Engine using the standard procedure in SQL ('sp_send_dbmail') that was previously configured and it is currently used from Import Master

We are using the command SQLExecuteStoredProcedure(sqlConnection, Proc, 0) and we don't know how to define the parameters requested by this procedure (recipient, body, etc.)

If we put only the name of the procedure (in the variable 'Proc') we get the error 'No global profile is configured. Specify a profile name in the @profile_name parameter'. We have tried to specify the parameters just after the procedure name but then we get the error 'Could not find stored procedure .....'

Is there anyone with some experience on this matter?

Thanks in advance,

Kind Regards,

Find more posts tagged with

FAQs, How-To's, and Best Practices

Comments

MikeLewis

Lorenzo,

I'll get you something over the weekend to show you how to set this up. You will need an Exchange Account with password for this purpose.

In the meantime, read Don’t Use SQL Server to Send Emails

Llorenç Tomas

Thanks a lot Mike, appreciate your help, I'm afraid I agree with you about using SQL Server mail so looking forward your instructions

Kind Regards,

Llorenç Tomas

Hi, I just did a try with 'MailDefineServer' and 'MailerSenderMail' in Engine using the same mail configuration as defined in SQL SERVER mail database but didn't work, got the error 'The operation has timed out', may be it is necessary define some additional mail configuration in some place?

MikeLewis

Version 11.

You should be able to set this up in Repository Administration.

Make sure the "Infor BI Scheduling" service is running on your Infor Web Server.

I would get help from support for this since you are now out of the SQL world, and in the Infor world.

Llorenç Tomas

Hi Mike, thanks for the information, yes, we already have defined the Repository data and the service 'Infor BI Scheduler' but it remains not working, we are going to report to support

Kind regards

Copyright © 2025 Infor. All rights reserved.