<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="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="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> |
</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> |