I am trying to send email to specific people when the jobs completes. the idea is to add the step in the job with the below code.
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'TEST Alert', -- Do I have to create first using DB mail?
@recipients = 'Email of the person or people you want to send',
@from_address = ',' -- I am wondering what this should be..?
@subject = 'TEST Scripts',
@body = 'The following scripts have been run successfully'
Error : Executed as user: ***. profile name is not valid [SQLSTATE 42000] (Error 14607). The step failed.