- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to get all scheduled oozie coordinator jobs
- Labels:
-
Apache Oozie
Created 11-26-2018 02:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Is there anyway from oozie backend db or command to find out how many oozie jobs are scheduled and running in entire clusters.
Created 11-26-2018 02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Saurabh,
oozie jobs -oozie http://oozieurl:11000/oozie/ -len 5 -filter status=RUNNING -jobtype=coord
Hope this helps!
Thanks
Created 11-26-2018 02:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created 11-26-2018 02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Saurabh,
oozie jobs -oozie http://oozieurl:11000/oozie/ -len 5 -filter status=RUNNING -jobtype=coord
Hope this helps!
Thanks
Created 11-27-2018 06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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) ?
Created 12-03-2018 05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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 ;