create automation basedon value of a table

newbie in using toad,iwiould like to ask how will i create an automation if i run a query with a result of “yes” it will run another report but if the table return “no” then it will not stop running until the table is “yes”. using toad version 11. thanks!