Create a Database Mail profile & Add the account to the profile

Create a Database Mail profile

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = ‘Default Public Profile’,
@description = ‘Default public profile for all users’;

Add the account to the profile

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = ‘Default Public Profile’,
@account_name = ‘SQL’,
@sequence_number = 1;