Flusso di lavoro ottimizzazione indici
Microsoft.SystemCenter.SqlJobs.OptimizeIndexes (Rule)
Element properties:
Member Modules:
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>