AnsweredAssumed Answered

I need to identifies every EBS job with Wait for Child Jobs set to No

Question asked by AmarnathReddy604762 on Jan 24, 2018
Latest reply on Jan 25, 2018 by AmarnathReddy604762

Like • Show 0 Likes0
Comment • 4

can you please help build sql query to identifies every EBS job with Wait for Child Jobs set to No.

Michael_Pirson Jan 24, 2018 7:53 PM

Correct Answer

I believe you are going to want the OCV table and the OCV_VName of childWait. I do not have any EBS job to test but I believe it is the same for all RA objects. However if you show me the whole OCV row from a specific RA EBS job I could probably get a query made up for this.

See the reply in context

No one else had this question

Outcomes

4 Replies

AmarnathReddy604762 Jan 24, 2018 2:44 PM
Mark Correct
Correct Answer
can you share any one to share table details for active/hold child jobs in workflow
Like • Show 0 Likes0
Actions
Michael_Pirson Jan 24, 2018 7:53 PM
Unmark Correct
Correct Answer
I believe you are going to want the OCV table and the OCV_VName of childWait. I do not have any EBS job to test but I believe it is the same for all RA objects. However if you show me the whole OCV row from a specific RA EBS job I could probably get a query made up for this.
Like • Show 0 Likes0
Actions
Alexander_Trenker_120 Jan 24, 2018 9:25 PM
Mark Correct
Correct Answer
Here's a simple query:

select oh_name,ocv_vname,ocv_value from oh,ocv where oh_idnr=ocv_oh_idnr and
ocv_vname='childWait' and
ocv_value='N'

The allowed values are Y and N.
Like • Show 1 Like1
Actions
AmarnathReddy604762 Jan 25, 2018 3:50 AM
Mark Correct
Correct Answer
Thanks Alexander ,

your query is very useful for me
Like • Show 0 Likes0
Actions

I need to identifies every EBS job with Wait for Child Jobs set to No

Outcomes

Related Content

Recommended Content