Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

How to get all scheduled oozie coordinator jobs

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

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

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

Expert Contributor

Hi @Saurabh,

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

Hope this helps!

Thanks

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

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 ;