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