That's a tough question.
It takes soooooo long for players to learn a new play, it's hard to know if the play doesn't work because it's a bad play, or because your team doesn't know it well enough yet.
I would normally wait at least half a season before I give up on a play.
FYI - Don't even bother trying any of the Shotgun running plays.