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
romeiovasuAsked:
Who is Participating?
 
TempDBAConnect With a Mentor Commented:
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
go

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.