question Re: How to get all scheduled oozie coordinator jobs in Archives of Support Questions (Read Only)

How to get all scheduled oozie coordinator jobs

SK1 — Mon, 26 Nov 2018 22:23:34 GMT

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

Re: How to get all scheduled oozie coordinator jobs

SK1 — Mon, 26 Nov 2018 22:25:44 GMT

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

sampathkumar_ma — Mon, 26 Nov 2018 22:45:22 GMT

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

SK1 — Tue, 27 Nov 2018 14:03:39 GMT

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

SK1 — Mon, 03 Dec 2018 13:56:00 GMT

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