Antoine_Sauteron_1266

Draw information from the Automation Engines's database

Discussion created by Antoine_Sauteron_1266 on Jan 25, 2017
Latest reply on Jan 25, 2017 by Antoine_Sauteron_1266
We need to create a "runbook".
But, there are some information which we do not know where to find in the database.
Could you please let us know where to find in the db
1. content of documentation tab for a specific job
2.  "earliest start time" and calendar condition from the task properties of child objects inside jobflow

1. This is stored in the ODOC table. However the content of the ODOC_Content column's content is encrypted and may not be accessed by a SQL query.

Oracle:
 g65fbht67ogi.png

MS SQL:
d7nvdcce9hsc.png

Besides interacting directly with the AE DB should be avoided when possible. Therefore we recommend to use PREP_PROCESS_DOCU instead.


2. Not sure this is exactly what you're looking for, but here goes:

A. Get calendar and keyword used in a workflow
SELECT OH_Name, JPPC_CaleName, JPPC_CaleKeyName
FROM OH, JPPC
WHERE OH_Idnr = JPPC_OH_Idnr
AND OH_Otype='JOBP'

B. Get the earliest start time:
SELECT OH_name, JPP_Object, JPP_ErlstStTime
FROM OH, JPP
WHERE OH_Idnr = JPP_OH_Idnr
AND JPP_ErlstStTime IS NOT NULL
Once again, I don't think A. is what you're looking for. However I'm pretty confident that somebody will read this post and come with a better proposition.

Best regards,
Antoine

Outcomes