SQL Maintenance Plan error “Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.”

 

SELECT c.action, o.name, b.name 
FROM sys.objects o
INNER JOIN sysprotects c
      ON o.object_id = c.id
INNER JOIN sysusers b
      ON c.uid = b.uid
WHERE o.type IN ('U','P','V')
AND b.name = 'LoginName'