added query to show open jobs