1 Reply Latest reply on Aug 12, 2020 5:05 PM by Haw Kor

    Control-M select jobs running more than 2 hours

    Fabiana Delfino
      Share This:

      Hey guys!

       

      Is there a way to select on the control-m database jobs that are running for more than an especific time?

       

       

      Regards,

       

      Fabiana

        • 1. Re: Control-M select jobs running more than 2 hours
          Haw Kor

          Fabiana,

           

          Are you talking about filtering active jobs to find jobs that are currently running longer than X hours or historically analyzing the jobs that run longer than X hours?

           

          If you are looking to historically figure this out you can query the runinfo_history table on the em database for the runtime that matches your criteria.  Something similar to the following to find jobs that run greater than 2 hours:

           

          select * from runinfo_history where run_time_sec > 7200

           

          I don't see any way to filter the AJF from the gui for jobs that are currently running longer than X hours. 

           

          Thanks,

           

          Haw

          1 of 1 people found this helpful