edited

opps ok so they removed the db in the name. Weird thing is I cant find sysmaintplan_plans in the list I can see _subplans, logdetail and _log bit no _plan...

OK got the answer to my own question

Note:
To use APPLY, the database compatibility level must be...

select

@@version;