1 Reply Latest reply on Nov 3, 2017 9:48 AM by Adil K

    on do action report extract through sql query

    Adil K

      Hello Team,

       

      i want to know which all jobs are holding information as when os completion status equals to 5 "rerun job" by searching through specific folders.

      How can this be achieved through sql query.

       

      Attached screen shot for reference.

      ondo.JPG

       

       

       

      Thanks

      Adil

        • 1. Re: on do action report extract through sql query
          Adil K

          well i solved the theory finally.

           

          here is the query for reference where you get the ondo actions under CMR_ONSTMT table using orderno as primary key you can link with CMR_AJF table to extract required info.

           

          select   b.JOBNAME, b.SCHEDTAB,a.CODE from CMR_ONSTMT a ,CMR_AJF b where a.ORDERNO= b.ORDERNO and a.CODE = 'COMPSTAT EQ 5' and  b.SCHEDTAB in ('<table_name>');

           

           

          Thanks

          Adil