Check for SQL Server Mail Profile

Check whether mail profile has been setup on the server.

The following will return mail profile that has been setup. The query will return no records if mail profile has not been setup.

USE msdb
GO 

SELECT 
	*
FROM 
	sysmail_principalprofile (NOLOCK) as PP
	INNER JOIN sysmail_profile (NOLOCK) as P ON PP.profile_id = P.profile_id