How to get all scheduled oozie coordinator jobs

[#1]

Hello,
Is there anyway from oozie backend db or command to find out how many oozie jobs are scheduled and running in entire clusters.

[#2]

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

[#3 · Accepted solution]

Hi @Saurabh,

oozie jobs -oozie http://oozieurl:11000/oozie/ -len 5 -filter status=RUNNING -jobtype=coord

Hope this helps!

Thanks

[#4]

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) ?

[#5]

@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 ;