VIEW: JTF.JTF_FM_SERVICE_ALL#

Source

View Text - Preformatted

select STARTUP_TIME STARTUP_TIME, SHUTDOWN_TIME SHUTDOWN_TIME, XML_DTD XML_DTD, STATUS STATUS, SERVER_ID SERVER_ID, DEQUEUE_WAIT_INTERVAL DEQUEUE_WAIT_INTERVAL, OPTIMUM_WRKR_THRDS OPTIMUM_WRKR_THRDS, MAX_WRKR_THRDS MAX_WRKR_THRDS, INPUT_QUEUE_THRESHOLD INPUT_QUEUE_THRESHOLD, 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, ORG_ID ORG_ID, F_DELETEDFLAG F_DELETEDFLAG, SERVICE_DESCRIPTION SERVICE_DESCRIPTION, DISPATCHER_QUEUE_NAME DISPATCHER_QUEUE_NAME, REQUEST_QUEUE_NAME REQUEST_QUEUE_NAME, ERROR_QUEUE_NAME ERROR_QUEUE_NAME, RESPONSE_QUEUE_NAME RESPONSE_QUEUE_NAME, SERVER_NAME SERVER_NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, IH_OUTCOME_ID IH_OUTCOME_ID, IH_SUCCESS_RESULT_ID IH_SUCCESS_RESULT_ID, IH_FAILURE_RESULT_ID IH_FAILURE_RESULT_ID, BATCH_REQUEST_Q BATCH_REQUEST_Q, MASS_REQUEST_Q MASS_REQUEST_Q, BATCH_PAUSE_Q BATCH_PAUSE_Q, MASS_PAUSE_Q MASS_PAUSE_Q, STATUS_REFRESH_RATE STATUS_REFRESH_RATE, UNSUBSCRIBE_FLAG UNSUBSCRIBE_FLAG, TRACK_OPEN_EMAIL TRACK_OPEN_EMAIL, RETURN_ADDRESS RETURN_ADDRESS, FROM_ADDRESS FROM_ADDRESS, RETURN_PATH RETURN_PATH, ENABLE_BOUNCEBACK ENABLE_BOUNCEBACK, IMAP_HOST IMAP_HOST, IMAP_PORT IMAP_PORT, ACCOUNT_NAME ACCOUNT_NAME, ACCOUNT_PASSWORD ACCOUNT_PASSWORD, RUN_FREQUENCY RUN_FREQUENCY, FROM_NAME FROM_NAME, RUN_FREQ_TIME_UNIT RUN_FREQ_TIME_UNIT, ZD_EDITION_NAME ZD_EDITION_NAME from "JTF"."JTF_FM_SERVICE_ALL"

View Text - HTML Formatted

SELECT STARTUP_TIME STARTUP_TIME
, SHUTDOWN_TIME SHUTDOWN_TIME
, XML_DTD XML_DTD
, STATUS STATUS
, SERVER_ID SERVER_ID
, DEQUEUE_WAIT_INTERVAL DEQUEUE_WAIT_INTERVAL
, OPTIMUM_WRKR_THRDS OPTIMUM_WRKR_THRDS
, MAX_WRKR_THRDS MAX_WRKR_THRDS
, INPUT_QUEUE_THRESHOLD INPUT_QUEUE_THRESHOLD
, 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
, ORG_ID ORG_ID
, F_DELETEDFLAG F_DELETEDFLAG
, SERVICE_DESCRIPTION SERVICE_DESCRIPTION
, DISPATCHER_QUEUE_NAME DISPATCHER_QUEUE_NAME
, REQUEST_QUEUE_NAME REQUEST_QUEUE_NAME
, ERROR_QUEUE_NAME ERROR_QUEUE_NAME
, RESPONSE_QUEUE_NAME RESPONSE_QUEUE_NAME
, SERVER_NAME SERVER_NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, IH_OUTCOME_ID IH_OUTCOME_ID
, IH_SUCCESS_RESULT_ID IH_SUCCESS_RESULT_ID
, IH_FAILURE_RESULT_ID IH_FAILURE_RESULT_ID
, BATCH_REQUEST_Q BATCH_REQUEST_Q
, MASS_REQUEST_Q MASS_REQUEST_Q
, BATCH_PAUSE_Q BATCH_PAUSE_Q
, MASS_PAUSE_Q MASS_PAUSE_Q
, STATUS_REFRESH_RATE STATUS_REFRESH_RATE
, UNSUBSCRIBE_FLAG UNSUBSCRIBE_FLAG
, TRACK_OPEN_EMAIL TRACK_OPEN_EMAIL
, RETURN_ADDRESS RETURN_ADDRESS
, FROM_ADDRESS FROM_ADDRESS
, RETURN_PATH RETURN_PATH
, ENABLE_BOUNCEBACK ENABLE_BOUNCEBACK
, IMAP_HOST IMAP_HOST
, IMAP_PORT IMAP_PORT
, ACCOUNT_NAME ACCOUNT_NAME
, ACCOUNT_PASSWORD ACCOUNT_PASSWORD
, RUN_FREQUENCY RUN_FREQUENCY
, FROM_NAME FROM_NAME
, RUN_FREQ_TIME_UNIT RUN_FREQ_TIME_UNIT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "JTF"."JTF_FM_SERVICE_ALL"