XML Table diff
<table name="ATSOverview">

  <sql_name>ATSOverview</sql_name>
  <singular_name>Administration Task</singular_name>
  <plural_name>Administration Tasks</plural_name>
  <inlinequery>
    <![CDATA[
      SELECT
          adminTaskList.TASKID,
          adminTaskStatus.STATUS,
          adminTaskList.NAME,
          adminTaskList.OWNER,
          adminTaskList.PROCEDURE_SCHEMA,
          adminTaskList.PROCEDURE_NAME,
          adminTaskStatus.RC,
          adminTaskStatus.INVOCATION,
          DATE(adminTaskStatus.BEGIN_TIME) as RUN_DATE,
          TIME(adminTaskStatus.BEGIN_TIME) as RUN_TIME,
          DATE(adminTaskStatus.END_TIME) as RUN_END_DATE,
          TIME(adminTaskStatus.END_TIME) as RUN_END_TIME
        FROM
            SYSTOOLS.ADMIN_TASK_LIST
              as adminTaskList
          LEFT OUTER JOIN
            SYSTOOLS.ADMIN_TASK_STATUS
              as adminTaskStatus
          ON
            adminTaskList.TASKID = adminTaskStatus.TASKID
    ]]>
  </inlinequery>
  <description>
    This view provides an overview of all administrative tasks scheduled within this database
  </description>
  <detail>n</detail>
  <rows_per_page>50</rows_per_page>
  <order_by_index></order_by_index>

  <display_columns>
    <col type="action" name="DETAILS"/>
    <col type="action" name="DELETETASK"/>
    <col type="action" name="EDIT"/>
    <col type="column" name="TASKID"/>
    <col type="column" name="STATUS"/>
    <col type="column" name="NAME"/>
    <col type="column" name="OWNER"/>
    <col type="column" name="PROCEDURE_SCHEMA"/>
    <col type="column" name="PROCEDURE_NAME"/>
    <col type="column" name="RC"/>
    <col type="column" name="INVOCATION"/>
    <col type="column" name="RUN_DATE"/>
    <col type="column" name="RUN_TIME"/>
    <col type="column" name="RUN_END_DATE"/>
    <col type="column" name="RUN_END_TIME"/>
  </display_columns>

  <action name="EDIT">
    <c_title>Edit</c_title>
    <icon>images/edit.gif</icon>
    <actionScript name="getTaskDetails" type="serverAction">
      <parameterList>
        <parameter name="action" type="raw">
          <value>executeSQL</value>
        </parameter>
        <parameter name="SQL" type="raw">
          <value>
            <![CDATA[
              SELECT
                  NAME,
                  DATE(BEGIN_TIME) as BEGIN_DATE,
                  TIME(BEGIN_TIME) as BEGIN_TIME,
                  DATE(END_TIME) as END_DATE,
                  TIME(END_TIME) as END_TIME,
                  MAX_INVOCATIONS, SCHEDULE,
                  REMARKS
                FROM
                  SYSTOOLS.ADMIN_TASK_LIST
                WHERE
                  TASKID = ?TASKID?
            ]]>
          </value>
        </parameter>
        <parameter name="parameter[TASKID]" type="blockValue">
          <value>TASKID</value>
        </parameter>
      </parameterList>
      <followOnAction condition="false">
        <task>
          <assignLocalParameter name="ERROR_MSG" type="returnObject">
            <value>getTaskDetails.returnValue.STMTMSG</value>
          </assignLocalParameter>
          <alert>Unable to retrieve row details. An error has occurred: ?ERROR_MSG?</alert>
        </task>
      </followOnAction>
      <followOnAction condition="true">
        <task>
          <panelReload/>
        </task>
      </followOnAction>
    </actionScript>
  </action>

  <action name="DELETETASK">
    <c_title>Remove</c_title>
    <icon>images/trash.gif</icon>
    <actionScript name="getTaskName" type="blank">
      <followOnAction condition="true">
        <task>
          <assignSharedConstant name="NAME" type="blockValue">
            <value>NAME</value>
          </assignSharedConstant>
          <action name="confirmDelete" type="confirm">
            <message>
              Confirm deletion of administration task: ?NAME?
            </message>
            <followOnAction condition="true">
              <task>
                <action name="dropTask" type="serverAction">
                  <parameterList>
                    <parameter name="action" type="raw">
                      <value>executeSQL</value>
                    </parameter>
                    <parameter name="SQL" type="fixed">
                      <value>
                        <![CDATA[
                          CALL SYSPROC.ADMIN_TASK_REMOVE(
                                            '?NAME?',
                                            NULL
                                          )
                        ]]>
                      </value>
                    </parameter>
                  </parameterList>
                  <followOnAction condition="false">
                    <task>
                      <assignLocalParameter name="ERROR_MSG" type="returnObject">
                        <value>dropTask.returnValue.STMTMSG</value>
                      </assignLocalParameter>
                      <alert>An error has occurred: ?ERROR_MSG?</alert>
                    </task>
                  </followOnAction>
                  <followOnAction condition="true">
                    <task>
                      <panelReload/>
                    </task>
                  </followOnAction>
                </action>
              </task>
            </followOnAction>
          </action>
        </task>
      </followOnAction>
    </actionScript>
  </action>
  
  <action name="DETAILS">
    <c_title>Details</c_title>
    <icon>images/sout.gif</icon>
    <actionScript name="loaddetails" type="blank">
      <followOnAction condition="true" compareOn="true" compareOnType="raw">
        <task>
          <assignLocalParameter name="TASKID" type="blockValue">
            <value>TASKID</value>
          </assignLocalParameter>
          <loadPage>
            <linkList>
              <link type="action" target="adminTaskDetail" window="_self" connectionRequired="y">
                <parameterList>
                  <parameter name="table">AdminTask/adminTaskView</parameter>
                  <parameter name="action">display</parameter>
                  <parameter name="taskid">?TASKID?</parameter>
                </parameterList>
              </link>
              <link type="action" target="adminStatusDetail" window="_self" connectionRequired="y">
                <parameterList>
                  <parameter name="table">AdminTask/adminStatusView</parameter>
                  <parameter name="action">display</parameter>
                  <parameter name="taskid">?TASKID?</parameter>
                </parameterList>
              </link>
            </linkList>
          </loadPage>
        </task>
      </followOnAction>
    </actionScript>
  </action>

  <column name="TASKID">
    <c_sql_name>TASKID</c_sql_name>
    <c_title>Task ID</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>n</c_drill>
  </column>

  <column name="STATUS">
    <c_sql_name>STATUS</c_sql_name>
    <c_title>Task status</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="NAME">
    <c_sql_name>NAME</c_sql_name>
    <c_title>Task name</c_title>
    <c_presentation>s</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="OWNER">
    <c_sql_name>OWNER</c_sql_name>
    <c_title>Owner</c_title>
    <c_presentation>s</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="PROCEDURE_SCHEMA">
    <c_sql_name>PROCEDURE_SCHEMA</c_sql_name>
    <c_title>Stored procedure schema</c_title>
    <c_presentation>s</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="PROCEDURE_NAME">
    <c_sql_name>PROCEDURE_NAME</c_sql_name>
    <c_title>Stored procedure name</c_title>
    <c_presentation>s</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="RC">
    <c_sql_name>RC</c_sql_name>
    <c_title>Last return code</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>n</c_drill>
  </column>

  <column name="INVOCATION">
    <c_sql_name>INVOCATION</c_sql_name>
    <c_title>Total times run</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>n</c_drill>
  </column>

  <column name="RUN_DATE">
    <c_sql_name>RUN_DATE</c_sql_name>
    <c_title>Last run date</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="RUN_TIME">
    <c_sql_name>RUN_TIME</c_sql_name>
    <c_title>Last run time</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>n</c_drill>
  </column>

  <column name="RUN_END_DATE">
    <c_sql_name>RUN_END_DATE</c_sql_name>
    <c_title>End date</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>y</c_drill>
  </column>

  <column name="RUN_END_TIME">
    <c_sql_name>RUN_END_TIME</c_sql_name>
    <c_title>End time</c_title>
    <c_presentation>n</c_presentation>
    <c_sort>y</c_sort>
    <c_drill>n</c_drill>
  </column>

</table>