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

...

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

...