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
Author
Message
Posted Wednesday, December 19, 2012 6:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:15 AM
Points: 184, Visits: 654
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.

Message
[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