How to resolve “No Global Profile Is Configured” issue in SQL Server

All you need to know to resolve a “No global profile is configured. Specify a profile name in the @profile_name parameter” error is to know that when it’s talking about a global profile, SQL Server is referring to a default profile in database mail.