Manage Synchronization Jobs - Intergraph Smart Materials - Installation & Upgrade - Hexagon

Intergraph Smart Materials Web Installation (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
2020 (10.0)

To improve the performance of business intelligence reports, some of the reports use separate database tables. To ensure that the reports use current data, synchronization jobs must be run on the database to synchronize the database tables. Synchronization jobs must be created and run for the following reports:

  • Adherence to Delivery Dates (-> uses Expediting data)

  • Agreement Supplement Comparison

  • Agreements and Line Items

  • Bill of Materials

  • Commodity Codes (Catalog Search)

  • Expediting

  • Idents (Full Listing)

  • MRRs per Day

  • On-Time Delivery

  • Procurement Progress

  • Procurement Status

  • Purchase Order Closeout Status

  • Requisitions

  • Shipment Tracking

Create a synchronization job

  1. Click Create New Job.

    BIRSynchronizationJobsJobs

  2. Type the name of the job in the Job box.

  3. Select the name of the report from the Report drop-down list.

  4. Select the project(s) for which the data should be synchronized from the Synchronized Projects list.

    SHARED Tip Use the Ctrl- or Shift-key to select multiple projects.

    • It depends on the selected report if this option is available.

    • If no project or - all - is selected, the data of all projects will be synchronized.

  5. Select the language(s) for which the data should be synchronized from the Synchronized Languages list.

    SHARED Tip Use the Ctrl- or Shift-key to select multiple languages.

    • It depends on the selected report if this option is available.

    • If no language or - all - is selected, the data for all languages will be synchronized.

  6. Click Job Start Date and select the date and time the job shall start.

  7. Select the frequency of the job execution from the Frequency drop-down list.

  8. Select All if all data should be synchronized, or From Last Sync if only data should be synchronized that changed since the last run of the synchronization job.

  9. Select Yes from the Active list to enable the job to be started by the DBMS scheduler.

    If No is selected, the job will not be scheduled, but you can run it manually by selecting the job in the list and clicking Synchronize Now.

  10. Click Save.

The scheduled jobs run automatically at the defined job start date with the defined frequency.

Edit a synchronization job

The existing jobs are displayed in the upper part of the page.

BIRSynchronizationJobsJobs

The result of the job is displayed in the Job Run Result cell. Possible values are:

  • Succeeded

  • Stopped

  • Failed - nnnnn (nnnnn indicates the Oracle error message code)

If the job was disabled while it was running, a result is not displayed.

The Last Run cell shows the date and time of the last synchronization, with a comment about modifications to database objects that are relevant for the report. The comment appears in red when objects have been modified and the synchronization job should run again.

If customer installed procedures (CIPs) have been modified, it is necessary to update the version number and the build number in the VERSION procedure in the concerning custom package because this procedure is used to track package modifications.

  1. Click .

    The job details are displayed in the Job Details section at the bottom.

  2. Edit the data you want to change.

  3. Click Save.

    SHARED Tip To delete the selected job, click Delete.

Ad-hoc synchronization

You can start a synchronization job immediately.

  1. Select the check box in the second column for the jobs you want to run.

  2. Click Synchronize Now.

BIRSyncJobDetails02