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.

[Home] [Help]

VIEW: AMS.AMS_TRIGGERS#

Source

View Text - Preformatted


select TRIGGER_ID TRIGGER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROCESS_ID PROCESS_ID, TRIGGER_CREATED_FOR_ID TRIGGER_CREATED_FOR_ID, ARC_TRIGGER_CREATED_FOR ARC_TRIGGER_CREATED_FOR, TRIGGERING_TYPE TRIGGERING_TYPE, TRIGGER_NAME TRIGGER_NAME, VIEW_APPLICATION_ID VIEW_APPLICATION_ID, START_DATE_TIME START_DATE_TIME, LAST_RUN_DATE_TIME LAST_RUN_DATE_TIME, NEXT_RUN_DATE_TIME NEXT_RUN_DATE_TIME, REPEAT_DAILY_START_TIME REPEAT_DAILY_START_TIME, REPEAT_DAILY_END_TIME REPEAT_DAILY_END_TIME, REPEAT_FREQUENCY_TYPE REPEAT_FREQUENCY_TYPE, REPEAT_EVERY_X_FREQUENCY REPEAT_EVERY_X_FREQUENCY, REPEAT_STOP_DATE_TIME REPEAT_STOP_DATE_TIME, METRICS_REFRESH_TYPE METRICS_REFRESH_TYPE, DESCRIPTION DESCRIPTION, TIMEZONE_ID TIMEZONE_ID, USER_START_DATE_TIME USER_START_DATE_TIME, USER_LAST_RUN_DATE_TIME USER_LAST_RUN_DATE_TIME, USER_NEXT_RUN_DATE_TIME USER_NEXT_RUN_DATE_TIME, USER_REPEAT_DAILY_START_TIME USER_REPEAT_DAILY_START_TIME, USER_REPEAT_DAILY_END_TIME USER_REPEAT_DAILY_END_TIME, USER_REPEAT_STOP_DATE_TIME USER_REPEAT_STOP_DATE_TIME, SECURITY_GROUP_ID SECURITY_GROUP_ID, NOTIFY_FLAG NOTIFY_FLAG, EXECUTE_SCHEDULE_FLAG EXECUTE_SCHEDULE_FLAG, TRIGGERED_STATUS TRIGGERED_STATUS, USAGE USAGE from "AMS"."AMS_TRIGGERS"

View Text - HTML Formatted

SELECT TRIGGER_ID TRIGGER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PROCESS_ID PROCESS_ID
, TRIGGER_CREATED_FOR_ID TRIGGER_CREATED_FOR_ID
, ARC_TRIGGER_CREATED_FOR ARC_TRIGGER_CREATED_FOR
, TRIGGERING_TYPE TRIGGERING_TYPE
, TRIGGER_NAME TRIGGER_NAME
, VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, START_DATE_TIME START_DATE_TIME
, LAST_RUN_DATE_TIME LAST_RUN_DATE_TIME
, NEXT_RUN_DATE_TIME NEXT_RUN_DATE_TIME
, REPEAT_DAILY_START_TIME REPEAT_DAILY_START_TIME
, REPEAT_DAILY_END_TIME REPEAT_DAILY_END_TIME
, REPEAT_FREQUENCY_TYPE REPEAT_FREQUENCY_TYPE
, REPEAT_EVERY_X_FREQUENCY REPEAT_EVERY_X_FREQUENCY
, REPEAT_STOP_DATE_TIME REPEAT_STOP_DATE_TIME
, METRICS_REFRESH_TYPE METRICS_REFRESH_TYPE
, DESCRIPTION DESCRIPTION
, TIMEZONE_ID TIMEZONE_ID
, USER_START_DATE_TIME USER_START_DATE_TIME
, USER_LAST_RUN_DATE_TIME USER_LAST_RUN_DATE_TIME
, USER_NEXT_RUN_DATE_TIME USER_NEXT_RUN_DATE_TIME
, USER_REPEAT_DAILY_START_TIME USER_REPEAT_DAILY_START_TIME
, USER_REPEAT_DAILY_END_TIME USER_REPEAT_DAILY_END_TIME
, USER_REPEAT_STOP_DATE_TIME USER_REPEAT_STOP_DATE_TIME
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, NOTIFY_FLAG NOTIFY_FLAG
, EXECUTE_SCHEDULE_FLAG EXECUTE_SCHEDULE_FLAG
, TRIGGERED_STATUS TRIGGERED_STATUS
, USAGE USAGE
FROM "AMS"."AMS_TRIGGERS"