Tuesday, December 20, 2022
How to stop and start DBmail
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
Subscribe to:
Post Comments (Atom)
https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...
-
SELECT is_broker_enabled, name FROM sys.databases All Availability Group Databases =0 It’s a default behavior. The message will ...
-
Hi, I have set up Always on Availability Groups on top of Windows Server Failover Cluster(WSFC) with two sql server stand alone installat...
No comments:
Post a Comment