ER diagram for AutoSys

Products

• Autosys Workload Automation

Issue/Introduction

Looking for details on the schema (all database objects) for AutoSys.

Resolution

The database objects are intended for use by the product.  Running custom queries against the tables could cause performance issue with the product and/or db.  As such, product mgmt. does not publish an ER diagram of the AutoSys or WCC database.  Additionally the product schemas do change from version to version some.  So a custom query developed against version X may not work after upgrading to version Y.  It is recommend clients leverage the commands and/or other utilities the product offers. Things such as autorep, autoaggr, monbro, WCC's reporting, and the AutoSys webserver (AEWS).  If the available tools do not provide the details needed please submit an enhancement request for consideration.