SQL statement for jobs in stats 1550 with names like JOBS.SOMTHING*

Discussion created by Tran-Hoang_Hau_348 on May 9, 2017
This question has been asked so far.

Can you guide me to what tables II'd need to create a query lit get all jobs like "JOBS.JDE%' that are in status 1550. 
a SYS_ACTIVE_COUNT with RUNNING is a little too broad for what I want.

All the Jobs/Tasks are running we can check again EH table, you can check the DB schema as below

A simple example of the below

Select *  from eh where EH_status='1550'and eh_name like '%JOB%' and EH_CLIENT='1'