There are many jobs in Clarity to generate data. Which ones are necessary and what order should they be scheduled?
The following is the suggested job scheduling for a typical Clarity Production environment to accommodate business needs and reporting and will provide end users with the most up-to-date information while providing optimal performance.
Jobs that provide data to the stock portlets and Jaspersoft reports
Run every minute. Get time-sliced data available in various internal and external slice tables. Examples:
Run only once per day, before the full Rate Matrix Extraction job
Run in sequential order:
Obtain realized actuals in the portlet (Posted Transactions Review) and/or Transactions List/Create WIP Adjustment page which are obtained from the PPA_WIP table.
Set each job as incompatible with the other. There are historic, live, and snapshot rates.
The incremental Rate Matrix Extraction job runs with the following options:
The full Rate Matrix Extraction job runs with the following options:
Run nightly at least once.
The job provides rates to the Post Timesheets job and baseline actions.
The following actions to obtain rates can be performed after the incremental or full Rate Matrix Extraction job completes:
Run the following jobs to get the Jaspersoft Advanced Reporting domains/reports populated.
If the financial posting module is used, be sure to follow the sequence of actions in KB: Transactions: posting / correcting / adjusting depending on the type of transaction.
The full Rate Matrix Extraction job will need to be run and complete before any of the posting jobs are ran.
If data needs to be archived or purged, please contact Support and provide a description of what Clarity data needs to be deleted or removed.