magritton
6/27/2015 - 1:44 PM

Test SQL operator to make sure the email system is working. Don't forget to enable alerts in the SQL Server Agent.

Test SQL operator to make sure the email system is working. Don't forget to enable alerts in the SQL Server Agent.

SQL Test Operator2.sql
content_copyfile_download
EXECUTE msdb.dbo.sp_notify_operator @name=N'xxxx',@subject=N'Log backup completed',@body=N'Log backup completed.....'
SQL Test Operator.sql
content_copyfile_download
use msdb
go
EXEC dbo.sp_notify_operator
   @profile_name = N'TestDev',
   @name = N'xxxx',
   @subject = N'Test Notification',
   @body = N'This is a test of notification via e-mail.' ;
GO