SQL 2016 using Maintenance Plans for backup automation

As per Microsoft documentation and with the courtesy of Microsoft, here is the detail about SQL maintenance plans
Make sure to review a link provided by Microsoft for a full explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/create-a-maintenance-plan?view=sql-server-2017

Using SQL Server Management Studio
To create a maintenance plan using the Maintenance Plan Wizard
In Object Explorer, click the plus sign to expand the server where you want to create a maintenance plan.

Click the plus sign to expand the Management folder.

Right-click the Maintenance Plans folder and select Maintenance Plan Wizard.

Follow the steps of the wizard to create a maintenance plan. For more information, see Use the Maintenance Plan Wizard.

To create a maintenance plan using the design surface
In Object Explorer, click the plus sign to expand the server where you want to create a maintenance plan.

Click the plus sign to expand the Management folder.

Right-click the Maintenance Plans folder and select New Maintenance Plan.

Create a maintenance plan following the steps in Create a Maintenance Plan (Maintenance Plan Design Surface).

Using Transact-SQL
To create a maintenance plan
In Object Explorer, connect to an instance of Database Engine.

On the Standard bar, click New Query.

Copy and paste the following example into the query window and click Execute.


Copy
USE msdb;
GO
-- Adds a new job, executed by the SQL Server Agent service, called "HistoryCleanupTask_1".
EXEC dbo.sp_add_job
@job_name = N'HistoryCleanupTask_1',
@enabled = 1,
@description = N'Clean up old task history' ;
GO
-- Adds a job step for reorganizing all of the indexes in the HumanResources.Employee table to the HistoryCleanupTask_1 job.
EXEC dbo.sp_add_jobstep
@job_name = N'HistoryCleanupTask_1',
@step_name = N'Reorganize all indexes on HumanResources.Employee table',
@subsystem = N'TSQL',
@command = N'USE AdventureWorks2012
GO
ALTER INDEX AK_Employee_LoginID ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
USE AdventureWorks2012
GO
ALTER INDEX AK_Employee_NationalIDNumber ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
USE AdventureWorks2012
GO
ALTER INDEX AK_Employee_rowguid ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
USE AdventureWorks2012
GO
ALTER INDEX IX_Employee_OrganizationLevel_OrganizationNode ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
USE AdventureWorks2012
GO
ALTER INDEX IX_Employee_OrganizationNode ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
USE AdventureWorks2012
GO
ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee REORGANIZE WITH ( LOB_COMPACTION = ON )
GO
',
@retry_attempts = 5,
@retry_interval = 5 ;
GO
-- Creates a schedule named RunOnce that executes every day when the time on the server is 23:00.
EXEC dbo.sp_add_schedule
@schedule_name = N'RunOnce',
@freq_type = 4,
@freq_interval = 1,
@active_start_time = 233000 ;
GO
-- Attaches the RunOnce schedule to the job HistoryCleanupTask_1.
EXEC sp_attach_schedule
@job_name = N'HistoryCleanupTask_1'
@schedule_name = N'RunOnce' ;
GO