Page History

...

Introduction 

The JobScheduler reporting interface Reporting Interface consists of two components:

• Database components such as tables and procedures
• Microsoft Excel template (JobSchedulerReporting.xlsx) with access to the database components

...

• 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

  • run report_procedure.sql DML script to crate required procedure

• 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

• 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 template sheet to the JobScheduler reporting database you have to update in "the following configuration files:

• The following ODC sample files are used to connect the database to the below reporting template.
  
  • The samples are provided for a PostgreSQL database and make use of the procedures that are installed with JobScheduler.
  • Adjust these samples to your needs, they are not under producte maintenance but used for instruction purposes.
• Inventory Reports
  • JobScheduler Reporting Interface -

...

• • Installed Job Objects.odc
  • JobScheduler Reporting Interface - Installed Order Objects.odc

...

• Execution Reports
  • JobScheduler Reporting Interface - Execution Summary.odc

Update - JobScheduler Reporting Interface - Execution Summary.odc

1. Open ODC file "JobScheduler Reporting Interface - Execution Summary.odc"  in any text editor 
2. update Update following settings with your JobScheduler database settings. 
   
   1. DATABASE
   2. SERVER
   3. PORT
   4. UID
   5. PWD 
3. Save ODC file 
4. close text editor

Update - JobScheduler Reporting Interface - Installed Job Objects.odc

• Open ODC file "JobScheduler Reporting Interface - Installed Job Objects.odc"  in any text editor and and repeat the steps from 2 to 4 from the previous section

...

• .

Update - JobScheduler Reporting Interface - Installed Order Objects.odc

• Open ODC file "JobScheduler Reporting Interface -

...

• Installed Order Objects.odc"  in any text editor and and repeat the steps from 2 to 4 from the previous section. 

Microsoft Excel Workbook

Configure - Execution Summary Report

1. open JobSchedulerReporting.xlsx 
   • 
     
     
2. open Execution Summary tab from the workbook
   
   • 
     
     
3. click on the cell B5 "Mandator" to select the Pivot table
   
   • 
     
     
4. click on the Data --> Connection  
   • 
     
     
     
5. double click on ODC file "JobScheduler Reporting Interface - Execution Summary"
   • 
     
     
6. select "Definition" tab and browse for the updated ODC file ( shared directory location)
   • 
     
     
7. click "Browse" , select the directory where ODC files are stored
   • 
     
     
8. select "JobScheduler Reporting Interface - Execution Summary.odc"  and click Open
   • 
     
     
     
9. next check "Always use connection file" 
10. also check "Save password" and click OK
    • 
      
      
11. click on the cell B5 "Mandator" to select the Pivot table , do a right click --> Refresh
    • 
      
      

Configure -  Execution Execution Summary Report: Monthly Executions

...

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,
   • 

...