Server configuration: Agent XPs
Applies to:
SQL Server
Use the Agent XPs
option to enable the SQL Server Agent extended stored procedures on this server. When this option isn't enabled, the SQL Server Agent node isn't 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. For more information, see Surface area configuration.
Note
Management Studio Object Explorer doesn't display the contents of the SQL ServerAgent node unless these extended stored procedures are enabled regardless of the SQL Server Agent service state.
The possible values are:
Value | Description |
---|---|
0 (default) |
SQL Server Agent extended stored procedures aren't available |
1 |
SQL Server Agent extended stored procedures are available |
The setting takes effect immediately without a server stop and restart.
Examples
The following example enables the SQL Server Agent extended stored procedures.
- Connect to the Database Engine from Microsoft SQL Server Management Studio.
- Select New Query from the menu.
- Copy and paste the following example into the query window, and select Execute.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για