Hi,

I am using following query to use db mail sending and this is not giving any error:

EXEC msdb.dbo.sp_send_dbmail @recipients= @EMail_ID ,

@subject = 'New Job Post' ,

@body = @Job_Description_brief ,

@body_format = 'HTML' ,

@profile_name = 'Profile Name';

It is running successfully. 🙂