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
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