Sending emails with Gmail or Hotmail using SQL Server Agent

• Monday, April 15, 2013 2:29 PM

   

   
  

  0

  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?

  • Reply
  • Quote