Ordered list of sessions in a batch, OPB_BATCH_SESSION

[finquattro]

Hey!

I am looking for an answer how to list names of all sessions in a batch and in an execution order.

By using the following query to the repository

SELECT * FROM OPB_LOAD_BATCH as b, OPB_LOAD_SESSION as s,OPB_BATCH_OBJECT as o
where o.PARENT_ID = b.BATCH_ID AND
s.SESSION_ID = BJECT_ID AND
s.SUBJ_ID = o.SUBJECT_ID AND
b.BATCH_NAME='b_BATCH_NAME';

I get all sessions of one bath but how to order them as they are ordered in a batch? There is a table (OPB_BATCH_SESSION) which name looks promising but it is empty.

Thanks
finquattro

 

[blom0344]

I have not found a direct solution either, but since the logging is also available in the repository, why not sequence the order in which sessions are run within a batch from the logtables?

If you need assistance in setting up the proper SQL, then let me know...

Ties Blom
Information analyst
tbl@shimano-eu.com