An entire plan is enclosed by the <executionPlan> element.
Plans are either simple or composite. A simple plan is a sequential list of steps that are executed on a particular set of target servers. A simple plan does not contain or call other plans. A composite plan is composed solely of other subplans. A composite plan is not directly targeted because each simple subplan can run on a different set of targets.
The <executionPlan> element has the following attributes:
xmlns – A required string that has the following value:
http://www.sun.com/schema/SPS |
xmlns:xsi – A required string that has the following value:
http://www.w3.org/ 2001/XMLSchema-instance |
xsi:schemaLocation – An optional string that has the following recommended value:
http://www.sun.com/schema/SPS plan.xsd |
name – A required attribute of type entityName, which is the name of the execution plan.
path – An optional attribute of type pathName, which is the absolute path of the execution plan. If this attribute is omitted, the root path (/) is used. The value must name a folder that exists at the time that the plan is saved.
description – An optional attribute that is a string that describes the execution plan.
version – A required attribute of type schemaVersion, which is the version of the plan schema that is being used. The only permitted values are 5.0 and 5.1.
The only permitted values are 5.0 and 5.1.
The <executionPlan> element has the following optional child elements, which must appear in the order shown. These child elements might have their own child elements, attributes, or both.
<paramList> – Declares a list of parameters for use by steps contained in the plan and any components that they reference
<varList> – Declares a list of variables for use by the steps contained in the plan and any components they reference
<simpleSteps> – Contains one or more “shared” or “simple plan only” steps
<compositeSteps> – Contains one or more “composite plan-only” steps