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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment