Fetch the RJ_KEY for the Scheduler Job (Trusted / Target Recon Job) and Fetch the count for the Job?

select MAX(RJ_KEY) from recon_jobs where RJ_NAME='Job Name';

NOTE : 

Job Name = Active Directory User Target Recon

select count(distinct re.re_key) as COUNT from RECON_JOBS rj, RECON_EVENTS re, RECON_HISTORY rh, USR usr where rj.RJ_NAME='Clarizen Certification Job' and rj.rj_key=re.rj_key and rh.re_key=re.re_key and rh.rh_status in ('Creation Succeeded','Update Succeeded') and re.usr_key=usr.usr_key and to_char(rj.rj_start_time,'DD/MM/YY') = to_char(SYSDATE,'DD/MM/YY') and rj.rj_key='RJ_KEY' order by rj.rj_start_time desc;

NOTE :

RJ_KEY = 1234