Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_send_dbmail Won't fire off email within SQL Agent Expand / Collapse
Author
Message
Posted Thursday, December 19, 2013 12:22 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 30, 2014 8:19 PM
Points: 1,406, Visits: 275
I can run the t-sql statement in management studio and I receive an email as expected using sp_send_dbmail

I cannot get sp_send_dbmail to work within a job. Notification emails are working within jobs so I am certain email is working to that extent.

I have changed the job owner to the account that is running SQL Server Agent and the account has sysadmin privileges.

I am running out of things to check.

Any suggestions?
Post #1524750
Posted Tuesday, December 24, 2013 3:24 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 10:45 AM
Points: 1,058, Visits: 2,696
Are you using dbmail inside job step and checking?

if it is can u post the code you are checking(after masking).


Regards
Durai Nagarajan
Post #1525721
Posted Friday, January 3, 2014 7:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 20, 2014 6:34 AM
Points: 31, Visits: 176
You've not given us any code, but is the email portion of your job a step of it's own? If so, do you have the database set to MSDB?
Post #1527525
Posted Monday, January 6, 2014 2:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:56 AM
Points: 39, Visits: 517
Hi,

Verify that you have enabled mail profile on the Alert System. This is on SQL Agent properties.

Regards
Post #1528001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse