"When do you know when to give up on a story?"

Over on Tumblr, rayray-monroe asked:

I know your an author and your probably busy, so i'll keep this quick, i want to be a writer and i was just wondering when do you know when to give up on a story? And is is possible to get a good career from writing?