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 - Technical Information - Standard Data Model
• see JobScheduler Reporting Interface - 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
   
  

  Error rendering macro 'viewxls'

  com.atlassian.confluence.macro.MacroExecutionException: com.atlassian.confluence.macro.MacroExecutionException: The viewfile macro is unable to locate the attachment "JobSchedulerReporting.xlsx" on this page

File Transfer Reporting

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