How to confiure SQLAgent Mail on Cluster

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to confiure SQLAgent Mail on Cluster

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2007-06-09 : 16:45:10

Hi all

We have two node cluster

The steps i have followed to create SQLAgentMail

1.Login to NODE1 to with the uset that started the SQL Services
2.Installe Microsoft Outlook
3.Create a profile for the mailbox (for the login user)
4.I have changed the Agent properies to set up the profile
5.All the jobs that have send mails tasks started working

Recently we have rebooted the server which automatically switched the server to NODE2 which do not has Outlook installed, So the jobs with maail tasks failing

I have done all the above steps to replicate the second server
and tried to restart the SQLAgent service, but the Agent is getting hung with the below messages

2007-06-09 13:50:05 - ! [257] Startup error: Another instance of SQLServerAgent is already servicing server instance MSSQLSERVER

An error 5023 - (The group or resource is not in the correct state to perform the requested operation.

) occurred while performing this service operation on the SQLServerAgent service.

The Operating system is Windows 2003 enterprise edition and SQL Server 2000 Enterprise Edtion

Can some one please help me in setting up SQLAgent Mail in Cluster Environment

Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-09 : 20:58:05

Double check in cluster admin to see if sql agent resource is running.