Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
The following example enables the SQL Server Agent extended stored procedures.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Documentation
Use the Maintenance Plan Wizard - SQL Server
Learn how to create a single or multiserver maintenance plan using the Maintenance Plan Wizard in SQL Server.
Maintenance Plan (Design Tab) - SQL Server
Maintenance Plan (Design Tab)
Back Up Database Task (Maintenance Plan) - SQL Server
Learn how to add a backup task to a maintenance plan in SQL Server by using the Back Up Database Task.