recently i was working on sending an email from the output of table and found below 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.
and i was able to start db mail and send emal
--START
USE msdb
GO
EXEC dbo.sysmail_start_sp
go
--STOP
USE msdb
GO
EXEC dbo.sysmail_stop_sp
No comments:
Post a Comment