JobScheduler Reporting Interface - Deployment

Introduction 

The JobScheduler reporting interface consists of two components:

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

Before we start reading the JobScheduler data from the database we need to create some database tables, procedures and mappings.

Once database objects are on place, Office Data Connection, i.e. ODC, need to be configured. We suggest to

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

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.

Update - JobScheduler Reporting Interface - Execution Summary.odc

1. Open ODC file "JobScheduler Reporting Interface - Execution Summary.odc"  in any text editor 
2. 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 Objects.odc

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

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 Summary Report: Monthly Executions

1. click on the workbook "Monthly Execution"
   • 
     
     
2. click on the cell B5 "Start Date" to select the Pivot table,
3. repeat 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,
   
   • 

Configure - Installed Job Object Report

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