Configuration Option agent XPs changed from 0 to 1

Question

Hi

A few days ago, on the log erro of the SQL Server i had the next message:

"[External]Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. "

The solution of the issue it´s not important, i need to know what
produced this issue, could be an administrator or a program? .

**I don´t have the windows event log because it´s recycled every day. Only the SQL log.

Thanks

Answer 1

If you don't have auditing set up for these kind of things, it is about impossible to find out after the fact.

It could be in the default trace if you are lucky, but I don't know this kind of event is captured there. And with five rollover files, the data in the default trace is not retained for a very long time.

Answer 2

I found the same question

https://social.msdn.microsoft.com/Forums/en-US/74282f02-6734-4b3c-a372-cf6f0944be29/what-changed-agent-xps-to-0?forum=sqldatabaseengine

Answer 3

Hi @Alexander Cardenas ,

Does your SQL server agent running now? Did you check your SQL server agent log to find some useful information? You can get them from SSMS UI when SQL agent running. Or you can get them from the default location C:\Program Files\Microsoft SQL Server\MSSQLX.MSSQLSERVER\MSSQL\Log.

Each SQL Server Agent Error log will record informational, warnings and different error messages which have occurred since SQL Server Agent was last restarted or since the last time you have recycled the SQL Server Agent Error Logs.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.