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

Email notification problem in sql server 2000 Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 9:04 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 8:38 PM
Points: 152, Visits: 826
I am getting error below error:

Error :22022 Sql server Agent error: The sql server agent mail is not running; Check the mail profile and/or the sql server agent service startup account sql server agent properties.


Please anyone help me..



Thanks
jeri
Post #1408482
Posted Thursday, January 17, 2013 9:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,216, Visits: 5,106
Ensure you have setup SQL Mail, set the alert system of the Agent to use SQL Mail and the profile, restart the Agent.

That should resolve your problems.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1408485
Posted Thursday, January 17, 2013 9:15 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 8:38 PM
Points: 152, Visits: 826
this profile had working last year 2012 27th, then outlook migrated cloud , after that we are getting error..

before that, notification is working fine.
Post #1408490
Posted Friday, January 18, 2013 1:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,216, Visits: 5,106
What troubleshooting have you done?

That bit of information would have been nice to have on the original post so we knew what had changed.

Can the SQL server ping the cloud mail server?
Can the SQL server telnet to the cloud mail server on the correct port?
Has the profile been updated to use the new cloud mail server?
Can you send mail from the outlook client on the SQL server via the cloud mail server?
Has the mail account actually been migrated to the cloud server?

Please provide as much information as you can on what you have tried so far to resolve this issue so that we are not repeating steps you have already taken.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1408763
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse