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?
I think something like this should get you the process text ..
SELECT OH_Idnr, ot.OT_Content FROM oh, otwhere oh.OH_Idnr = ot.OT_OH_Idnrand oh.OH_Name = 'JOBS.UNIX.NEW.1'and ot.OT_Type = 0and oh.OH_Client = 6
Obviously changing/parameter the job name and the client number for where the job lives...
Thanks Dan, works like a charm :-)
Retrieving data ...