Automic Workload Automation

Expand all | Collapse all

SQL to extract content of Process tab

Jump to Best Answer
  • 1.  SQL to extract content of Process tab

    Posted 05-22-2018 06:37 AM

    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.



  • 2.  Re: SQL to extract content of Process tab
    Best Answer

    Posted 05-22-2018 06:52 AM

    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



  • 3.  Re: SQL to extract content of Process tab

    Posted 05-22-2018 07:13 AM

    Thanks Dan, works like a charm :-)



  • 4.  Re: SQL to extract content of Process tab

    Posted 05-22-2018 08:34 AM

    No problem