In book canon, Jedi failures get shipped off to an agricultural corps, where they get to use their half-fledged Force sensitivity to grow plants, detect problem areas and generally the order can pretend they don't exist.

Pretty awful, really, although there's a lot of rhetoric about "the agricultural corps are TOO an honorable position!"