Re: How to schedule a task in QMC based on SQL Query?
I don't think you can write a condition in QMC.
As Andrea mentioned you can run or stop your extraction based on stat_cd<>2
when your QMC task kicks in it would run the load in app, if the condition is satisfied it would fetch the records or exit the script.
If you transform is dependent on your extract then maybe you'd have to give condition there as well but either way in QMC the task would not fail and all the depended tasks would run but not get new records.