You do not need to be working to sponsor your spouse.
But if you are a canadian citizen who lives abroad and wants to sponsor their spouse, you will need to show that you intend to live in Canada after your spouse gets the visa, in this case, it is good to show that you have a job offer, or leased a house, as a proof.
But if you are residing in Canada and have PR or Citizenship, you can simply sponsor your spouse.
That is what I know.
Am I right? Any other comments?