View JOB's Data Select Sql Script

If check the JOB’s data select  on db server ， you can use following SQL script：
   
    SELECT A.JCUSER,A.JCJOBNBR, JDAUDINFO,B.JCPID,B.JCVERS,A.JCJOBSTS,
     A.JCENHV,A.JCFNDFUF2,B. JCSTDTIM,B.JCETDTIM,
     JDEXEHOST,JDJOBNBR FROM    SVM900.F986110 A
     left join SVM900.F986114 B ON A.JCJOBNBR=B.JCJOBNBR
     LEFT JOIN SVM900.F986114A C ON A.JCJOBNBR=C.JDJOBNBR
     WHERE
     JDEXEHOST = 'JDEDB' AND JDJOBNBR = 5296.000000 AND JDAUDTYP = '02'  ;

Note:

 1. the db of owner ：SVM900， is my JDE environment, you can replace your.

 2. on the WHERE the JDJOBNBR is the JOB number.

 3. JDAUDTYP=’02‘ mean the JOB's data select,  '01':Processing Options , '03':Sorting, '04':Report Interconnect Structure,'05':SQL Scripts

 4. You can use the PL/Sql Developer to run the script , click the column:JDAUDINFO value to see the detail, because the field data type is NCLOB.