<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> <assignSharedConstant name="NAME" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.0</value> </assignSharedConstant> <assignSharedConstant name="BEGIN_DATE" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.1</value> </assignSharedConstant> <assignSharedConstant name="BEGIN_TIME" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.2</value> </assignSharedConstant> <assignSharedConstant name="END_DATE" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.3</value> </assignSharedConstant> <assignSharedConstant name="END_TIME" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.4</value> </assignSharedConstant> <assignSharedConstant name="MAX_INVOCATIONS" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.5</value> </assignSharedConstant> <assignSharedConstant name="SCHEDULE" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.6</value> </assignSharedConstant> <assignSharedConstant name="REMARKS" type="returnObject"> <value>getTaskDetails.returnValue.resultSet.0.data.0.7</value> </assignSharedConstant> <action name="getNewValuesForTask" type="form"> <parameterList> <parameter name="action" type="raw"> <value>getHeadlessTableForm</value> </parameter> <parameter name="table" type="raw"> <value>AdminTask/atsTaskEdit</value> </parameter> </parameterList> <followOnAction condition="true"> <task> <assignSharedConstant name="MAX_INVOCATIONS_TO_SUBMIT" type="constant"> <value>MAX_INVOCATIONS</value> |
<check> <onMatch condition="^$"> <task> </task> </onMatch> </check> |
</assignSharedConstant> <action name="editTask" type="serverAction"> <parameterList> <parameter name="action" type="raw"> <value>executeSQL</value> </parameter> <parameter name="SQL" type="fixed"> <value> <![CDATA[ CALL SYSPROC.ADMIN_TASK_UPDATE( '?NAME?', ?BEGIN_DATETIME?, ?END_DATETIME?, ?MAX_INVOCATIONS_TO_SUBMIT?, ?SCHEDULE_SUBMIT?, null, '?REMARKS?' ) ]]> </value> </parameter> </parameterList> <followOnAction condition="false"> <task> <assignLocalParameter name="ERROR_MSG" type="returnObject"> <value>editTask.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="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> |