I've created an Operator with my personal gmail account and I've created an alert job to alert me whenever Tracked transactions/sec rises above 10.
I've ran this test query to test the emails system
USE AdventureWorks2012
Go
CREATE TABLE NuggetDemos.t1(c1 int)
GO
DECLARE @counter int
SET @counter = 1
WHILE (@counter <= 20000)
BEGIN
PRINT @counter
INSERT NuggetDemos.t1
SELECT @counter
SET @counter += 1
END
GO
SELECT * FROM NuggetDemos.t1
But alas I'm not receiving any notifications. What am I doing wrong here?
Do I need to setup a profile using Database Mail? if so, what are the smtp details of either gmail or hotmail?