This page (revision-21) was last changed on 11-Mar-2022 15:52 by Lilia Urtan

This page was created on 26-Nov-2021 10:22 by UnknownAuthor

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
21 11-Mar-2022 15:52 2 KB Lilia Urtan to previous

Page References

Incoming links Outgoing links
IMEX
IMEX

Version management

Difference between version and

At line 4 changed one line
The Define Executions & Report Scheduling (IMEX) allows you to view database sessions that occurred on a specific day.
The Define Executions & Report Scheduling (IMEX) allows you to view scheduled executions and reports.
At line 8 changed 5 lines
;[Scheduled By|]:
;[Status|EXECUTION_STATUS]:
;[Schedule Start Date|SCHEDULED_START_DATE]:
;[Start Date|]:
;[User Name|USER_NAME]:
;[Scheduled By|]:This field displays the execution id number.
;[Status|EXECUTION_STATUS]:This field shows the status of the execution log.
;[Schedule Start Date|SCHEDULE_START_DAY]:The date the report/execution are scheduled for are displayed in this field.
;[Start Date|EXECUTION_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.
;[Identity|PERSON_CODE]:The identity information of the person running the process is displayed in this field
At line 15 changed 4 lines
;[Schedule Start Date|SCHEDULE_START_DATE]:
;[Run Start Date|SCHEDULE_START_DAY]:
;[Output|]:
;[Cancel Schedule|]:
;[Schedule Start Date|SCHEDULE_START_DAY]: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.
At line 21 changed 7 lines
;[Frequency|SCHEDULE_FREQUENCY]:
;[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|]:
;[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]:This field specifies which weekday of the month the process should be run on. (e.g. First, Second, Third, Fourth, Fifth).
;[Weekdays|SCHEDULE_WEEKDAYS]:This field identifies which day of the week the process should run on. (e.g. Mon, Tues, Wed, ...)
;[Schedule Expiry Date|SCHEDULE_EXPIRY_DATE]:This field allows you indicate when the repeat run process will end.
;[Save and Schedule|]:This button allows you to save and schedule the execution/report.
At line 29 changed 2 lines
;[Parameter Name|PARAMETER_NAME]:
;[Value|PARAMETER_VALUE]:
;[Parameter Name|PARAMETER_NAME]:This field displays the parameters of the report.
;[Value|PARAMETER_VALUE]:The value of the parameter is displayed in this field.
At line 32 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 34 changed 46 lines
![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]| |
![Notes|Edit:Internal.IMEX]
[{InsertPage page='Internal.IMEX' default='Click to create a new notes page'}]
This page (revision-21) was last changed on 11-Mar-2022 15:52 by Lilia UrtanTop