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
This field shows the status of the execution log.
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