To delete or update profiles, accounts, profile-account associations, and profile security settings (note: do so in reverse order), you use the stored procedures shown in Table 12.1.
For example, to delete a profile, you execute this:
exec msdb.dbo.sysmail_delete_profile_sp @profile_name='Undesireable Profile Name'
To update a profile’s security, changing it from the default to the nondefault profile, you execute the following:
exec msdb.dbo.sysmail_update_principalprofile_sp @profile_name = 'Default ...