MS SQL Maintenance Plan Help!

I?m trying hard to figure out what the write way of managing our SQL server is. We have sporadic success. Sometimes the jobs work sometimes they do not.

We would like to implement an effective MS SQL Maintenance Plan. Should we use the wizard or something else, not sure?

Sorry if this question was asked 50 million times. I?m new here.

The Transaction Log Backup job we created using the wizard doesn?t work anymore. Can some help.

EXECUTE master.dbo.xp_sqlmaint N’-PlanID 4EC1FB53-8846-4604-B520-5157BE9213AF -WriteHistory -BkUpOnlyIfClean -CkDBRepair -BkUpMedia DISK -BkUpLog -UseDefDir -DelBkUps 2WEEKS -BkExt “TRN”‘