eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPLSYS.AD_SESSIONS_HISTORY#

Source

View Text - Preformatted


select SESSION_ID SESSION_ID, UTILITY_NAME UTILITY_NAME, APPL_TOP_PATH APPL_TOP_PATH, INVOKDIR INVOKDIR, STATUS STATUS, PRIORITY PRIORITY, START_DATE START_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, END_DATE END_DATE, COMPLETION_STATUS COMPLETION_STATUS, RUN_ON_NODE RUN_ON_NODE, CONTEXT_INFO CONTEXT_INFO, ANY_CHANGE_WHILE_INACTIVE_FLAG ANY_CHANGE_WHILE_INACTIVE_FLAG, JS_TOTAL_JOBS JS_TOTAL_JOBS, JS_COMPLETED_JOBS JS_COMPLETED_JOBS, JS_REMAINING_JOBS JS_REMAINING_JOBS, LOCKS_OVERRIDDEN_BY LOCKS_OVERRIDDEN_BY, TOPDIR TOPDIR from "APPLSYS"."AD_SESSIONS_HISTORY"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, UTILITY_NAME UTILITY_NAME
, APPL_TOP_PATH APPL_TOP_PATH
, INVOKDIR INVOKDIR
, STATUS STATUS
, PRIORITY PRIORITY
, START_DATE START_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, END_DATE END_DATE
, COMPLETION_STATUS COMPLETION_STATUS
, RUN_ON_NODE RUN_ON_NODE
, CONTEXT_INFO CONTEXT_INFO
, ANY_CHANGE_WHILE_INACTIVE_FLAG ANY_CHANGE_WHILE_INACTIVE_FLAG
, JS_TOTAL_JOBS JS_TOTAL_JOBS
, JS_COMPLETED_JOBS JS_COMPLETED_JOBS
, JS_REMAINING_JOBS JS_REMAINING_JOBS
, LOCKS_OVERRIDDEN_BY LOCKS_OVERRIDDEN_BY
, TOPDIR TOPDIR
FROM "APPLSYS"."AD_SESSIONS_HISTORY"