One solution I see is to have a singleton orchestration that check your table column at desired intervals and then perform action according to Y or N flag…
Or maybe you could have an SQL jobb that sends a XML message to a folder if the flag is N, this will trigger the orch. and you could monitor the table column flag and terminate the orch if it's Y…
just some rapid ideas…