April 6, 2012 at 1:46 am
Experts,
I restarted one of our SQL Server Service.
After restarting the service, SQL server agent was stopped with "Agent XPs disabled" next to it and I was not able to start it. (One of the database was "In Recovery" status, and became available after 15 mnts, I dont know if it has anything to do with it.). Anyway I referred the below link for Sql Server Agent issue.
http://technet.microsoft.com/en-us/library/ms190730.aspx
Thing is that I didn't do anything at all. But the SQL server Agent was started automatically after some time. I really don't understand how it started automatically when I have not changed any settings.
Has anyone had any such experience ?.
Thanks,
Smith.
April 6, 2012 at 8:23 am
Joy Smith San (4/6/2012)
I restarted one of our SQL Server Service.After restarting the service, SQL server agent was stopped with "Agent XPs disabled" next to it and I was not able to start it. (One of the database was "In Recovery" status, and became available after 15 mnts, I dont know if it has anything to do with it.). Anyway I referred the below link for Sql Server Agent issue.
http://technet.microsoft.com/en-us/library/ms190730.aspx
Thing is that I didn't do anything at all. But the SQL server Agent was started automatically after some time. I really don't understand how it started automatically when I have not changed any settings.
Has anyone had any such experience ?.
Did you check SQL Agent Log to learn exactly what happened?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply