Compatibility

• JobScheduler Releases
  • JobScheduler Reporting Interface availability:  FEATURE AVAILABILITY STARTING FROM RELEASE 1.9
  • The JobScheduler Reporting Interface is compatible for JobScheduler release 1.8 (requires manual installation)
• DBMS
  • The JobScheduler Reporting Interface has been tested for compatibility with the following DBMS:
    • PostgreSQL 9.x
    • MySQL 5.x
    • Oracle 11g, 12g
    • SQL Server 2008, 2012
  • Newer DBMS versions might be compatible

Implementation

Job Reporting

Data Model

• see JobScheduler Reporting Interface (1.9.x, 1.10.x) - Technical Information - Standard Data Model
• see JobScheduler Reporting Interface (1.9.x, 1.10.x) - Technical Information - Data Model Customization

Report ODC Connectivity Sample 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

Report Template

• Excel Template for use with the Standard Data Model: JobSchedulerReporting.xlsx

Change Management References

File Transfer Reporting

• Not in scope of the first release of the Reporting Interface