• you don't get my point previously it was working fine

    let me tell you step by step

    for testing purpose i am executing like below

    EXEC msdb..sp_send_dbmail

    @profile_name = 'profilename'

    ,@recipients = 'test@vcmpartners.com'

    ,@subject = 'test mail'

    ,@body_format = 'HTML'

    ,@body = 'test mail'

    ,@from_address = 'prod@vcmpartners.com'

    it's show me error

    Msg 14641, Level 16, State 1, Procedure sp_send_dbmail, Line 81

    Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail.

    as per error suggest

    EXEC msdb.dbo.sysmail_start_sp; ----- to start database mail

    also check status through

    EXEC msdb.dbo.sysmail_help_status_sp;

    it's shows me started

    after that if i try to send it's show me

    mail queued

    but i don't get any mail

    again if i start to send test mail it's shows me same error and what's it's relation to sql agent mail enable or disable

    Raj Acharya