Shulou(Shulou.com)05/31 Report--

What is the definition of the sql2005 Agent XPs option? for this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

When you add sql server's mantenance to the sql2005 database, "agent xps component is turned off" is prompted on the server. Let's start with what Agent XPs is: this item is used to determine whether the child nodes under the SQL Server proxy node are displayed in the SQL Server Management Studio. This item is disabled by default when the proxy service is not started; it is enabled after the service is started. Possible values are:

Use the Agent XPs option to enable SQL Server agent extended stored procedures on this server. If you disable this option, SQL Server Management Studio object Explorer will not display the SQL Server proxy node. These extended stored procedures are automatically enabled when you start the SQL Server Agent service using the Surface area Configurator tool.

The following example illustrates enabling the SQL Server agent extension stored procedure.

Sp_configure 'show advanced options', 1 / GORECONFIGURE / GOSPP configure' Agent XPs', 1 / GORECONFIGUREGO

If we need to see the current settings of Agent XPs, we can run the query: the sp_configure 'Agent XPs', query returns five columns of results, where run_value is the current running value. The parameter of adding mantenance is determined by config_value, which needs to be changed to "1". The value of run_value depends on which node the server-side Agent service is running on. As long as this node is Active, its corresponding run_value value is 1. Our previous problem needs to be solved by modifying config_value, which has nothing to do with the value of run_value. This change has no impact on the operation of the database instance.

0, which means that the SQL Server agent extension stored procedure is not available (the default).

1, indicating that the SQL Server agent extension stored procedure is available.

This setting takes effect immediately and there is no need to stop and restart the server.

The answer to the question about the definition of sql2005 Agent XPs options is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.