get all view jobs query