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

Send email from SQL Agent Job error - Restarting SQL Server Agent service with mirroring? Expand / Collapse
Posted Wednesday, December 19, 2012 6:24 AM


Group: General Forum Members
Last Login: Wednesday, October 22, 2014 7:10 AM
Points: 193, Visits: 684
I have setup Database mail and can send emails from SQL server with no issues. However when emailing a notification from a SQL job it fails.

[264] An attempt was made to send an email when no email session has been established

I have setup the alert system on the SQL Server Agent and enabled a mail profile.

I think the reason its not working is I need to do a SQL Server Agent service restart, however I'm worried about doing this as we have mirroring setup on the server. Will this impact mirroring and other jobs?

Many thanks
Post #1398354
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse