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

Version management

Difference between version and

At line 4 changed one line
The Define Executions & Report Scheduling (IMEX) allows you to view scheduled executions and reports.
The Define Executions & Report Scheduling (IMEX) allows you to view database sessions that occurred on a specific day.
At line 6 changed one line
Data for the 'Define Executions & Report Scheduling' screen is maintained on the [P2K_AM_FUNCTIONS], [P2K_AM_EXECUTIONS] and [P2K_AM_PARAMETER_VALUES] tables.
Data for the 'View Instance Alerts By Day' screen is maintained on the [P2K_AM_SESSION_AUDITS] table.
At line 8 changed 6 lines
;[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
;[Scheduled By|]:
;[Status|]:
;[Schedule Start Date|]:
;[Start Date|]:
;[User Name|]:
At line 16 changed 4 lines
;[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.
;[Schedule Start Date|]:
;[Run Start Date|]:
;[Output|]:
;[Cancel Schedule|]:
At line 22 changed 7 lines
;[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.
;[Frequency|]:
;[Frequency Amount|]:
;[Frequency Option|]:
;[Day Repeat|]:
;[Weekdays|]:
;[Schedule Expiry Date|]:
;[Save and Schedule|]:
At line 30 changed 2 lines
;[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.
;[Parameter Name|]:
;[Value|]:
At line 32 added one line
[{If var='loginstatus' contains 'authenticated'
At line 34 changed 2 lines
![Notes|Edit:Internal.IMEX]
[{InsertPage page='Internal.IMEX' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.IMEX]
[{InsertPage page='Internal.IMEX' default='Click to create a new discussion page'}]
}]