How to find Job Definition Details in Database

Products

• ESP dSeries Workload Automation
• ESP dSeries Workload Automation - Scheduler (dSeries)
• DSERIES- SERVER

Issue/Introduction

We want to know in which DB table the defined application's job details are stored in. 

 

Environment

ESP dSeries Workload Automation

Resolution

Instead of querying the database, it is recommended to use the The Import and Export Utility. With that you can export all applications to xml files and then look for the data you need in the files. 

If the querying the DB is absolutely necessary, the job details (definition - not runtime) can be found in the ESP_AMS_DF table -> DEFINITION column (CLOB) where ARTIFACTTYPE='APPLICATION'. 

Note that no manual update of the database is recommended; must ensure this guideline is followed to maintain system stability.