Index Optimization Workflow

Microsoft.SystemCenter.SqlJobs.OptimizeIndexes (Rule)

Element properties:

Target	Microsoft.ServiceManager.SqlJobWorkflowTarget
Category	Maintenance
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	System.Scheduler	Microsoft.SystemCenter.DatabaseWriteActionAccount
WA	WriteAction	Microsoft.SystemCenter.SqlJobExecuter	Microsoft.SystemCenter.DatabaseWriteActionAccount

Source Code:

<Rule ID="Microsoft.SystemCenter.SqlJobs.OptimizeIndexes" Enabled="true" Target="Microsoft.ServiceManager.SqlJobWorkflowTarget" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>Maintenance</Category>

  <DataSources>

    <DataSource ID="DS" RunAs="SCLibrary!Microsoft.SystemCenter.DatabaseWriteActionAccount" TypeID="System!System.Scheduler">

      <Scheduler>

        <SimpleReccuringSchedule>

          <Interval Unit="Days">1</Interval>

          <SyncTime>03:00</SyncTime>

        </SimpleReccuringSchedule>

        <ExcludeDates/>

      </Scheduler>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WA" RunAs="SCLibrary!Microsoft.SystemCenter.DatabaseWriteActionAccount" TypeID="Microsoft.SystemCenter.SqlJobExecuter">

      <JobName>p_OptimizeIndexes</JobName>

    </WriteAction>

  </WriteActions>

</Rule>