I’ve had pretty amazing luck with JBWeld. It is strong. But if you are trying to plug a leak with oil currently leaking out, I’m not sure how well it will adhere to the oily metal. Long term I would definitely get a new transmission cover.