Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to get all scheduled oozie coordinator jobs

avatar
Guru

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

1 ACCEPTED SOLUTION

avatar
Expert Contributor

Hi @Saurabh,

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

Hope this helps!

Thanks

View solution in original post

4 REPLIES 4

avatar
Guru

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

avatar
Expert Contributor

Hi @Saurabh,

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

Hope this helps!

Thanks

avatar
Guru

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

avatar
Guru

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