Tran-Hoang_Hau_348

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 

https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE/latest/DB%20Schema/db/_structure/HTML/index.htm#ucaaiy.htm%3FTocPath%3DUser%2520Guide%7CObjects%7CWorking%2520with%2520Objects%7CReturn%2520Codes%7C_____1
https://docs.automic.com/documentation/WEBHELP/English/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucaaiy.htm%3FTocPath%3DUser%2520Guide%7CObjects%7CWorking%2520with%2520Objects%7CReturn%2520Codes%7C_____1

A simple example of the below

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

Outcomes