While doing my consulting, I created a maintenance plan for my client to take full and log backups on a regular basis. The client was a little impatient, and he wanted to test everything before I get off the call. So, they tried to execute the maintenance plan which I created. It failed like below
When we click on a hyperlink, we see below message. Here is the text of the message.
Maintenance Plan ‘Full and Log Backup’ contains multiple subplans. You can execute them individually by selecting their associated jobs under the SQL Server Agent node of Object Explorer. (SqlManagerUI)
The error message appeared because I created to subplans in the same plan. Below is the screenshot when we edit the plan. As we can see Subplan_1 is for full backup and another one was for log backup.
WORKAROUND / SOLUTION
As mentioned in the error message, I need to use SQL Server Agent to pick the job and run the subplan which I need to run.
Rather than having names like Subplan_1, I prefer to rename the subplan by editing, maintenance plan to have some meaningful names. Here is what I do.
I hope this blog has helped you in fixing errors and a trick to get the job name little more meaningful when it’s created via maintenance plan.
Reference: Pinal Dave (https://blog.sqlauthority.com)