April 22, 2017 at 9:21 am
Hello Team,
Our SQL instance was restarted couple of days back. Later we got to know that someone has restarted the agent for some reason.
can you please let me know how to find who or what restarted this agent service
Regards
Atulyan
April 22, 2017 at 9:30 am
If the SQL instance is stopped, this will effect Agent as well. If you stop the SQL instance, you'll need to start Agent for that instance up again too. Are you mistaking that as the instance was restarted that agent was as well (as it would have to be)?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 22, 2017 at 9:37 am
Hi Thom
Thank you for your prompt reply... but there is time lag between the two restarts
April 22, 2017 at 1:51 pm
Which of the following are you seeing?
SQL Server Instance is stopped.
SQL Server Agent for the instance also stops (due to stopping).
SQL Server Instance starts.
SQL Server Agent for that instance starts.
--Later...
SQL Server Agent for Instance stops.
SQL Server Agent for Instance starts.
Or....
SQL Server Instance is stopped.
SQL Server Agent for the instance also stops (due to stopping).
SQL Server Instance starts.
--Later...
SQL Server Agent for Instance starts.
For former implies that someone stop and starter/restarted the SQL Server Agent service, Finding out who wwill likely be difficult, especially depending on what account was used to restart it. Can you see if an account authenticated to the Server around that time?
If the latter, then someone simply "forgot" to start Agent when the Instance was restarted. If you stop the Instance, even via restart, Agent will also be stopped. you have to start Agent as well after a (re)start.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply