question

Jim Orten avatar image
Jim Orten asked

Is log message about Agent XPs normal?

On the shutdown of a SQL Server 2005 instance I see this:

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

On the startup of the instance I see this:

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

Is this normal?

sql-server-2005sql-agent
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jim Orten avatar image Jim Orten commented ·
This was the 666th question? Yikes!!
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered

Yes this is normal. The XP agent always sets to 0 when instance is rebooted.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.