Compatibility

• JobScheduler Releases
  • JobScheduler Reporting Interface availability: 

    Display feature availability
    StartingFromRelease 1.9

  • The JobScheduler Reporting Interface is compatible for JobScheduler release 1.8 (requires
  manually installation)
  • 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

• JobScheduler 1.9.x, 1.10.x
  
  • 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
• JobScheduler 1.11.x
  
  • see JobScheduler Reporting Interface (1.11.x) - Technical Information - Standard Data Model
  • see JobScheduler Reporting Interface (1.11.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 with sample reports corresponding to requirements

  Documentation

  ...

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

  Change Management References

  Jira
  server SOS JIRA columns type,key,issuelinks,fixversions,status,priority,summary,updated maximumIssues 20 jqlQuery labels in (reporting) serverId 6dc67751-9d67-34cd-985b-194a8cdc9602

  ...

  File Transfer Reporting

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