How to create maintenance plan in SQL Server? How to create maintenance plan in SQL Server? sql-server sql-server

How to create maintenance plan in SQL Server?


You need to enable the SQL Server Agent extended stored procedures first by running the following.

sp_configure 'show advanced options', 1;GORECONFIGURE;GOsp_configure 'Agent XPs', 1;GORECONFIGUREGO