Job failed due to No global profile is configured. Specify a profile name in the @profile_name parameter

To day there is job failed in one of the our server.

Below is the error:

No global profile is configured. Specify a profile name in the @profile_name parameter

Work around:-

We verified the profile name and default setting using below query. Profile is not set default that is the reason it got failed.

EXEC msdb.dbo.sysmail_help_principalprofile_sp;

Return Code Values

0 (success) or 1 (failure)

is _default -The flag that states whether the profile is the default profile for the user.

Solution:

1. Login into the serve
2. Open run and type SQLWB\SSMS
3. Connect to server
4. Go to maintenance tab
5. Select the Database Mail
6. Right click Database Mail and start the wizard
7. Click on next
8. Select the manage profile security
9. Click on next
10. Go to the Default profile and select Yes
11. Click on next button
12. Click on finish
13. Click on close

Then reran the job it was successfully completed with out errors.

Screen shots: