Wednesday, August 11, 2010

Starting and Stopping DB Mail in 2008 R2

While I know for any SQL DB Admin this is rudimentary knowledge, I wanted to bring this to any ones attention on the way to start and stop DB mail in SQL Server 2008 R2. This is done via stored procedures in msdb.

To Start DB Mail:
exec dbo.sysmail_start_sp

To Stop DB Mail:
exec dbo.sysmail_stop_sp

To Verify DB Mail has started:
exec dbo.sysmail_help_status_sp

To Review The Mail Log:

SELECT * FROM msdb.dbo.sysmail_event_log