Duong_Nguyen-Nhat_2335

SQL Queries for Statistics of given JOBS/JOBP

Discussion created by Duong_Nguyen-Nhat_2335 on Jul 22, 2016
Latest reply on Aug 4, 2016 by Christian_Boeck_57
The below queries used for getting the statistic of given JOBS/JOBP:

select *
from AH
where AH_OH_IDNR = ( 
select OH_IDNR from OH 
where OH_CLIENT = 100 
and OH_NAME = 'JOBS.WIN.NEW.TEST2' 
);

Please replace your Client and Jobs Name to pass your system.

More Information about the database Schema, please take a look at the following link:

http://docs.automic.com/documentation/AE/11.2/english/AE_DB_TABLES/tables/index.htm 

Outcomes