Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to get all scheduled oozie coordinator jobs

Solved Go to solution

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

Accepted Solutions

Re: How to get all scheduled oozie coordinator jobs

Expert Contributor

Hi @Saurabh,

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

Hope this helps!

Thanks

4 REPLIES 4
Highlighted

Re: How to get all scheduled oozie coordinator jobs

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

Re: How to get all scheduled oozie coordinator jobs

Expert Contributor

Hi @Saurabh,

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

Hope this helps!

Thanks

Re: How to get all scheduled oozie coordinator jobs

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

Re: How to get all scheduled oozie coordinator jobs

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 ;