Product Knowledge Base

Space shortcuts

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version 2

changes.mady.by.user Andreas Püschel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • put the ODC file at a centralized location accessible to all users. 
  • then to configure ODC file location in the JobSchedulerReporting.xlsx and to freely distribute JobSchedulerReporting.xlsx to intended users.

Database Components

Database DDL/DML scripts

  • Execute - report.sql 

    • run report.sql DDL script to create required table structure

  • Execute - report_procedure.sql

  • Execute - report_insert.sql

    • This script is used to populate the mapping tables for mandators and applications that are related to jobs. Therefore the content of that script is specific for each customer and contains just some sample records provided by SOS.
    • run report_insert.sql DML script to initialize mapping tables

Metadata Table

Info
titleMetadata tables are customer specific. To map jobs with mandator and application, customer has to preare inserts from there environment. CSI can select Jobscheduler_history table , from Job Chain name then can crate Mandator i.e. first three character of the Job Chain name etc.

As for CSI the metadate shall be extracted from the folder names that contain character sequences that specify the mandator and application.

 

  • Table - report_job

    • Insert the Job/Job Chain name into the NAME column and Title in to TITLE column

  • Table - report_mandator

    • Insert the mandator name into the NAME column and the Title into the TITLE column

  • Table - report_appliction

    • Insert the application name into the NAME column and the Title/Description into the TITLE column

Mapping Tables

  • Table - report_map_job_application

    • Link the Job/Job Chain with the Application 

  • Table - report_map_job_mandator

    • Link the Job/Job Chain with the Mandator

Connectivity Components

Office Data Connection ODC files

ODC files contains the database connection and data selection settings. To connect the JobSchedulerReporting.xlsx sheet to the JobScheduler database you have to update in "JobScheduler Reporting Interface - Execution Summary.odc" and "JobScheduler Reporting Interface - Installed Objects.odc" the following database settings.

...

  1. Click on the workbook "Installed Job Objects"


  2. click on the cell B5 "Start Date" to select the Pivot table,


  3. repeat step 4 to 10 from (Execution Summary Report) for the ODC file "JobScheduler Reporting Interface - Installed Objects" 


  4. click on the cell B5 "Start Date" to select the Pivot table,

 

 

...