IMEX
Back to current versionRestore this version

Table of Contents

DEFINE EXECUTIONS & REPORT SCHEDULING#

The Define Executions & Report Scheduling (IMEX) allows you to view database sessions that occurred on a specific day.

Data for the 'Define Executions & Report Scheduling' screen is maintained on the P2K_AM_FUNCTIONS, P2K_AM_EXECUTIONS and P2K_AM_PARAMETER_VALUES tables.

Scheduled By
Status
Schedule Start Date
Start Date
User Name

Scheduling#

Schedule Start Date
Run Start Date
Output
Cancel Schedule

Repeat Options#

Frequency
Frequency Amount
Frequency Option
Day Repeat
Weekdays
Schedule Expiry Date
Save and Schedule
Parameter Name
Value

CLEANUP

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
MFN_IDNumber(10)IDYlink to P2K_AM_FUNCTIONS
MUS_IDNumber(10)IDYlink to P2K_AM_USERS
DESTINATIONVarchar2(30)VARCHAR30
SUBMIT_FRAMEVarchar2(30)VARCHAR30
TIME_WINDOWVarchar2(30)VARCHAR30
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
EXECUTION_STATUSVarchar2(2)X_EXECUTION_STATUSY
EXECUTION_START_DATEDate()TIMESTAMP
EXECUTION_END_DATEDate()TIMESTAMP
PRIORITYNumber(5)NUMBER5
PRINT_IMMEDIATELYVarchar2(1)TOGGLE
RETURN_CODEVarchar2(2)X_RETURN_CODE
CPU_ELAPSED_TIMENumber(10)NUMBER10
DESFORMATVarchar2(10)X_DESFORMAT
DESNAMEVarchar2(4000)VARCHAR4000
DESTYPEVarchar2(7)X_DESTYPE
REPORT_MODEVarchar2(10)X_REPORT_MODE
PRINT_ORIENTATIONVarchar2(9)X_PRINT_ORIENTATION
PROGRESS_MESSAGEVarchar2(200)VARCHAR200
SCHEDULE_FREQUENCYVarchar2(10)X_REPORT_FREQUENCY
SCHEDULE_SUFFIXVarchar2(10)X_REPORT_SUFFIX
SCHEDULE_SUFFIX_AMOUNTNumber(10)NUMBER10
SCHEDULE_DAYREPEATVarchar2(2)X_DAYREPEAT
SCHEDULE_WEEKDAYSVarchar2(2)X_WEEKDAYS
SCHEDULE_DATE_OPTIONSVarchar2(2)X_DATE_OPTIONS
SCHEDULE_START_DAYVarchar2(16)VARCHAR16
SCHEDULE_START_TIMENumber(5)MINUTES
EXPIRES_DATE_OPTIONSVarchar2(2)X_DATE_OPTIONS
EXPIRES_VALUEVarchar2(16)VARCHAR16
PAGESTREAMVarchar2(1)TOGGLE
JOB_NAMEVarchar2(30)VARCHAR30
SCHEDULE_START_DATEDate()DATE
SCHEDULE_EXPIRY_DATEDate()DATE
SCHEDULE_START_DATEDate()TIMESTAMP

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation