This rule is used internally to execute database maintenance tasks and jobs. This rule should not be overridden as it will have an adverse negative impact the overall health, functionality, and consistency of the operational database.
This section is not applicable for this type of rule.
There is no user action for this type of rule.
Target | Microsoft.SystemCenter.AllManagementServersPool |
Category | Maintenance |
Enabled | True |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | System.Scheduler | Default |
WA | WriteAction | Microsoft.SystemCenter.SqlJobExecuter | Default |
<Rule ID="Microsoft.SystemCenter.SqlJobs.OptimizeIndexes" Enabled="true" Target="SCLibrary!Microsoft.SystemCenter.AllManagementServersPool" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>Maintenance</Category>
<DataSources>
<DataSource ID="DS" TypeID="System!System.Scheduler">
<Scheduler>
<SimpleReccuringSchedule>
<Interval Unit="Days">1</Interval>
<SyncTime>02:30</SyncTime>
</SimpleReccuringSchedule>
<ExcludeDates/>
</Scheduler>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WA" TypeID="Microsoft.SystemCenter.SqlJobExecuter">
<JobName>p_OptimizeIndexes</JobName>
</WriteAction>
</WriteActions>
</Rule>