locked
Sending emails with Gmail or Hotmail using SQL Server Agent RRS feed

  • Question

  • 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?

    Monday, April 15, 2013 2:29 PM

Answers