Gift Peddie (8/7/2011)
The question is who decides what normal use of the Agent because what you and the poster described is corporate internal use and where I work now we don’t have such setup. But we run a system fully integrated with Oracle 10g which is located in Michigan and the SQL Server in Florida. Another thing to consider saying your use is the required use when it will not meet the needs of 90 percent or more web operations is not practical.
So, you give advice that doesn't match recommended practices because that is what you believe is needed in your environment. Got it...
I don't see how integrating with Oracle has anything to do with this. Integrating with Oracle does not require that SQL Server Agent be a part of the local administrator's group on a Windows Server. I don't know where you get that information - but would really like to understand how you came up with that as a requirement.
Again - based on the documentation you referenced, which states that for the additional functionality of autorestart the agent service account needs to be a local administrator. So, I will ask again:
What functionality does that provide in your environment? Why is it required to 'integrate' with Oracle?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs