SQLServerAgentTools.Format.ps1xml
|
<?xml version="1.0" encoding="utf-8" ?>
<Configuration> <Controls> <Control> <Name>JobHistory-GroupingFormat</Name> <CustomControl> <CustomEntries> <CustomEntry> <CustomItem> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Server : </Text> <ExpressionBinding> <PropertyName>Server</PropertyName> </ExpressionBinding> </CustomItem> </Frame> <NewLine/> <Frame> <LeftIndent>4</LeftIndent> <CustomItem> <Text>Job Name : </Text> <ExpressionBinding> <PropertyName>JobName</PropertyName> </ExpressionBinding> </CustomItem> </Frame> </CustomItem> </CustomEntry> </CustomEntries> </CustomControl> </Control> </Controls> <ViewDefinitions> <View> <Name>AgentSubsystem</Name> <ViewSelectedBy> <TypeName>SqlServerAgent.AgentSubsystem</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>SubSystem</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Description</Label> <Width>50</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Max Worker Threads</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>SubSystem</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Description</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>MaxWorkerThreads</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>ErrorLogRecord</Name> <ViewSelectedBy> <TypeName>SqlServerAgent.ErrorLogRecord</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Log Date</Label> <Width>25</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Error Level</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Text</Label> <Width>75</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>LogDate</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ErrorLevel</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Text</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>JobHistory</Name> <ViewSelectedBy> <TypeName>SqlServerAgent.JobHistory</TypeName> </ViewSelectedBy> <GroupBy> <PropertyName>JobID</PropertyName> <CustomControlName>JobHistory-GroupingFormat</CustomControlName> </GroupBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Run Date</Label> <Width>22</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Instance ID</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>StepID</Label> <Width>6</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>StepName</Label> <Width>16</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>SqlSeverity</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>RunStatus</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>RunDuration</Label> <Width>12</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>RunDate</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>InstanceID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StepID</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>StepName</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>SqlSeverity</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RunStatusDescription</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>RunDuration</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> <View> <Name>MsxEncryptChannelOption</Name> <ViewSelectedBy> <TypeName>SqlServerAgent.MsxEncryptChannelOption</TypeName> </ViewSelectedBy> <TableControl> <!-- ################ TABLE DEFINITIONS ################ --> <TableHeaders> <TableColumnHeader> <Label>Job Server</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Channel Option</Label> <Width>20</Width> <Alignment>left</Alignment> </TableColumnHeader> <TableColumnHeader> <Label>Description</Label> <Width>50</Width> <Alignment>left</Alignment> </TableColumnHeader> </TableHeaders> <TableRowEntries> <TableRowEntry> <TableColumnItems> <TableColumnItem> <PropertyName>JobServer</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>ChannelOption</PropertyName> <Alignment>left</Alignment> </TableColumnItem> <TableColumnItem> <PropertyName>Description</PropertyName> <Alignment>left</Alignment> </TableColumnItem> </TableColumnItems> </TableRowEntry> </TableRowEntries> </TableControl> </View> </ViewDefinitions> </Configuration> |