[{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]: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|SCHEDULE_SUFFIX]:This field specifies the time basis of the Frequency Amount. (e.g. minutes, days, hours, weeks, months) based on the fixed lexicon.
;[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]| |