Description | Just paste this code in an empty xml file save it and include it in the user defined extension section as "Navigator"
<?xml version="1.0" encoding="windows-1252" ?>
<navigator RESOURCE_FILE="oracle.dbtools.raptor.navigator.OracleNavigatorResource"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="navigator.xsd">
<objectType connType="Oracle" id="JOB" weight="100.0" includesSyns="true">
<folder>
<icon RSKEY="TABLE_FOLDER_ICON"/>
<label RSKEY="Jobs"/>
<queries>
<query minversion="8">
<sql constrained="true">
<![CDATA[SELECT job,what,broken,job||' * '||substr(what,0,20) what_short FROM ALL_JOBS WHERE SCHEMA_USER=:SCHEMA]]>
</sql>
</query>
<columns>
<column filterable="true" sortable="true" id="JOB">
<colName>
<![CDATA[JOB]]>
</colName>
</column>
<column filterable="false" sortable="true" id="NAME">
<colName>
<![CDATA[WHAT_SHORT]]>
</colName>
</column>
<column filterable="true" sortable="true" id="WHAT">
<colName>
<![CDATA[WHAT]]>
</colName>
</column>
<column filterable="true" sortable="true" id="BROKEN">
<colName>
<![CDATA[BROKEN]]>
</colName>
</column>
</columns>
</queries>
</folder>
<node>
<icon RSKEY="OracleIcons.TABLE"/>
</node>
</objectType>
</navigator> |