SQL to extract content of Process tab

[Keld Mollnitz]

Hi,

 

Is anyone able to help me and produce a SQL query (Oracle) to extract the content of the Process tab of a certain Job name?

 

/Keld.

[Legacy User]

Hello,

 

I think something like this should get you the process text ..

 

SELECT OH_Idnr, ot.OT_Content
FROM oh, ot
where oh.OH_Idnr = ot.OT_OH_Idnr
and oh.OH_Name = 'JOBS.UNIX.NEW.1'
and ot.OT_Type = 0
and oh.OH_Client = 6

 

Obviously changing/parameter the job name and the client number for where the job lives...

 

Cheers,

 

Dan

[Keld Mollnitz]

Thanks Dan, works like a charm :-)

[Legacy User]

No problem