DEFINE EXECUTIONS & REPORT SCHEDULING#

The Define Executions & Report Scheduling (IMEX) allows you to view scheduled executions and reports.

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
This field displays the execution id number.
Status
This field shows the status of the execution log.
Schedule Start Date
The date the report/execution are scheduled for are displayed in this field.
Start Date
This field displays the actual start date of the execution.
User Name
The individual who scheduled the execution is identified in this field.

Scheduling#

Schedule Start Date
The date the report/execution are scheduled for are displayed in this field.
Run Start Date
This field displays the actual start date of the execution.
Output
The report file is available through this field.
Cancel Schedule
This button allows you to cancel a scheduled execution.

Repeat Options#

Frequency
This field specifies how often the process will run
Frequency Amount
This field specifies the interval of time between runs if the Frequency is “Every”, expressed in the time basis of the Frequency Option. (e.g. a value of 2 with a basis of ‘Days’ means ‘Every 2 Days’)
Frequency Option
This field specifies the time basis of the Frequency Amount. (e.g. minutes, days, hours, weeks, months) based on the fixed lexicon.
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