extended schedule query to coop with non-active schema's