Post reply

How do I know whether an profile is already created for email

  • June 20, 2016 at 11:35 am

    #319489

    Hello

    EXEC msdb.dbo.sp_send_dbmail @recipients = 'boomba@gmail.com' , @copy_recipients = NULL,

    @blind_copy_recipients = NULL, @subject = 'test', @body = 'test',

    @body_format = 'TEXT', @profile_name = 'mhpmis';

    How do I fond what profiles already exist in the server ?

  • June 20, 2016 at 11:49 am

    #1885897

    SELECT name FROM msdb..sysmail_profile

  • June 21, 2016 at 3:32 am

    #1885968

    EXEC msdb.dbo.sysmail_help_profile_sp

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply