Is there anyway from oozie backend db or command to find out how many oozie jobs are scheduled and running in entire clusters.
I ran following commands and its giving me enough info except owner details.So is there anyway to know who is owned those jobs.
oozie jobs -jobtype coordinator -len 10000000 | grep-i RUNNING
Hello @Sampath Kumar, It does not help because it does not give me coordinator owner name and it is same as I have mentioned above(oozie jobs -jobtype coordinator -len 10000000 | grep-i RUNNING).
So is there anyway to get this info from backend db (mysql) ?
@Sampath Kumar, I have got all the required details via running sql on oozie db in mysql.
select id,app_name,user_name,frequency,time_unit,start_time from oozie.COORD_JOBS where id in (select DISTINCT id from oozie.COORD_JOBS where status='RUNNING') order by start_time asc ;