When you create a new plan, remember that the execution plan requires the SQL Agent service (SQL Server Agent) to also open the Maintenance dialog box: "SQL Server has blocked access to the process ' dbo.sp_set_sqlagent_properties ' of component ' Agent XPs ' because this component has been shut down as part of this server's security configuration." SQL Server blocked access to the process ' dbo.sp_set_sqlagent_properties ' of component ' Agent XPs ' because this component was shut down as part of this server's security configuration. System administrators can enable ' Agent XPs ' by using sp_configure. For more information about enabling ' Agent XPs ', see "surface area Configurator" in SQL Server Books Online. (. Net SqlClient Data Provider). "
execute the following SQL statement to resolve:
1sp_configure'Show advanced Options',1;2 Go3 Reconfigure;4 Go5 6sp_configure'Agent XPs',1;7 Go8 Reconfigure;9 Go
usage Scenarios for database planning:Open the Agent service (SQL Server agent), create a new schedule (Maintenance plan), perform a backup schedule every Wednesday, Friday, and Sunday 1 o'clock, make a full backup of the Kenmuportal database, and the backup file is stored in the "C: \ Kenmutemp\backup folder, save only the most recent week of Bak backup files.
Results:
sp_configure command to open the component agent XPs, Database Plan (Maintenance plan)