Easier said than done, but... I believe the 'answer' is to find a mix of:
1) Find your strengths (technical and soft). Stick with what you are good at. You want to be known as the company's best... whatever (DBA, ? programmer, security analyst, etc). Quality work done on time and on budget will be valued by a quality company.
If you have soft skills (communication, leadership, adaptability, able to handle criticism/pressure, etc) you should at least consider management. Maybe you could find someone willing to let you 'shadow' for a day. * Being able to understand other people's strengths and weaknesses (as applied to contributing value to the company) is important.
2) You should at least like the work. Of course, it is best if you love it. If you hate the work, you will quit or get fired (because you will slack off - a 'form' of quitting). It may also help to work in an industry that you like (especially if you were to get a management position).
Example: You discover a passion for database work ;) . You become your company's best DBA. You get rewarded with good pay and recognition. Then, you feel inclined to enhance your skills further, becoming even more valuable... etc.
BEWARE. The success cycle is a binary snowball! It is on or off. A bit of humor, but seriously do not put yourself in a position/company/etc that makes you miserable. You would just 'snowball' in the 'off'.