We help IT Professionals succeed at work.

sql 2008 dbmail

iam getting the following error.

it was working fine before.

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
Watch Question

the error is self-explanatory. It happend becuase the database mail is stopped. YOu need to restart it.
Then you need to check why it happend? you can check logs for that.
Run the folllowing stored procedure.

exec msdb.dbo.sysmail_start_sp