Agent XPs Server Configuration Option

Use the Agent XPs option to enable the SQL Server Agent extended stored procedures on this server.

When this option is not enabled, the SQL Server Agent node is not available in SQL Server Management Studio Object Explorer.

When you use the SQL Server Management Studio tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically.

The possible values are:

  • 0, indicating that SQL Server Agent extended stored procedures are not available (the default).
  • 1, indicating that SQL Server Agent extended stored procedures are available.

    The setting takes effect immediately without a server stop and restart.

following example enables the SQL Server Agent extended stored procedures.

From Microsoft SQL Server Management Studio connect to the Database Engine.

From the Standard bar, click New Query.

 

Copy and paste the following example into the query window and click Execute.

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Agent XPs’, 1;
GO
RECONFIGURE
GO

 

After executing you can remove it now

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s