T_SQL for Creating a maintenance plan (via a maintenance Wizard)

BACKUP DATABASE [Horizon] TO  DISK = N''C:\Program Files\Microsoft SQL Server\MSSQL11.HORIZON\MSSQL\Backup\Horizon_backup_2017_11_30_160011_4475778.bak'' WITH NOFORMAT, NOINIT,  NAME = N''Horizon_backup_2017_11_30_160011_4475778'', SKIP, REWIND, NOUNLOAD,  STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N''Horizon'' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N''Horizon'' )
if @backupSetId is null begin raiserror(N''Verify failed. Backup information for database ''''Horizon'''' not found.'', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N''C:\Program Files\Microsoft SQL Server\MSSQL11.HORIZON\MSSQL\Backup\Horizon_backup_2017_11_30_160011_4475778.bak'' WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND

GO