[{TableOfContents }] !!!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|EXECUTION_STATUS]:This field shows the status of the execution log. ;[Schedule Start Date|SCHEDULED_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|USER_NAME]:The individual who scheduled the execution is identified in this field. !Scheduling ;[Schedule Start Date|SCHEDULE_START_DATE]:The date the report/execution are scheduled for are displayed in this field. ;[Run Start Date|SCHEDULE_START_DAY]: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|SCHEDULE_FREQUENCY]:This field specifies how often the process will run ;[Frequency Amount|SCHEDULE_SUFFIX_AMOUNT]: ;[Frequency Option|SCHEDULE_SUFFIX]: ;[Day Repeat|SCHEDULE_DAYREPEAT]: ;[Weekdays|SCHEDULE_WEEKDAYS]: ;[Schedule Expiry Date|SCHEDULE_EXPIRY_DATE]: ;[Save and Schedule|]: ;[Parameter Name|PARAMETER_NAME]: ;[Value|PARAMETER_VALUE]: [CLEANUP] [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.IMEX] [{InsertPage page='Internal.IMEX' default='Click to create a new discussion page'}] }] ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[MFN_ID]|Number(10)|[ID]|Y|link to [P2K_AM_FUNCTIONS] |[MUS_ID]|Number(10)|[ID]|Y|link to [P2K_AM_USERS] |[DESTINATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[SUBMIT_FRAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[TIME_WINDOW]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[EXECUTION_STATUS]|Varchar2(2)|[X_EXECUTION_STATUS]|Y| |[EXECUTION_START_DATE]|Date()|[TIMESTAMP]| | |[EXECUTION_END_DATE]|Date()|[TIMESTAMP]| | |[PRIORITY]|Number(5)|[NUMBER5|NUMBERn]| | |[PRINT_IMMEDIATELY]|Varchar2(1)|[TOGGLE]| | |[RETURN_CODE]|Varchar2(2)|[X_RETURN_CODE]| | |[CPU_ELAPSED_TIME]|Number(10)|[NUMBER10|NUMBERn]| | |[DESFORMAT]|Varchar2(10)|[X_DESFORMAT]| | |[DESNAME]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[DESTYPE]|Varchar2(7)|[X_DESTYPE]| | |[REPORT_MODE]|Varchar2(10)|[X_REPORT_MODE]| | |[PRINT_ORIENTATION]|Varchar2(9)|[X_PRINT_ORIENTATION]| | |[PROGRESS_MESSAGE]|Varchar2(200)|[VARCHAR200|VARCHARnn]| | |[SCHEDULE_FREQUENCY]|Varchar2(10)|[X_REPORT_FREQUENCY]| | |[SCHEDULE_SUFFIX]|Varchar2(10)|[X_REPORT_SUFFIX]| | |[SCHEDULE_SUFFIX_AMOUNT]|Number(10)|[NUMBER10|NUMBERn]| | |[SCHEDULE_DAYREPEAT]|Varchar2(2)|[X_DAYREPEAT]| | |[SCHEDULE_WEEKDAYS]|Varchar2(2)|[X_WEEKDAYS]| | |[SCHEDULE_DATE_OPTIONS]|Varchar2(2)|[X_DATE_OPTIONS]| | |[SCHEDULE_START_DAY]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[SCHEDULE_START_TIME]|Number(5)|[MINUTES]| | |[EXPIRES_DATE_OPTIONS]|Varchar2(2)|[X_DATE_OPTIONS]| | |[EXPIRES_VALUE]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[PAGESTREAM]|Varchar2(1)|[TOGGLE]| | |[JOB_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[SCHEDULE_START_DATE]|Date()|[DATE]| | |[SCHEDULE_EXPIRY_DATE]|Date()|[DATE]| | |[SCHEDULE_START_DATE]|Date()|[TIMESTAMP]| |