Was watching this, and it gave me an idea:
http://www.youtube.com/watch?v=Ww3GTNv9hHkWe need dwarf jobs that generate no items or no wealth, but will make other dwarfs happy. A couple ideas that I had...
1. Massage room/chair. The dwarf in charge of this would just hang out in this room all day until approached by a dwarf who is on break. This dwarf will get a massage and get a boost to happiness.
2. Singers. This dwarf will wonder your fortress singing. Probably have him patrolling around workshops and meeting areas and avoiding bedrooms. Dwarfs that particularly enjoy music may even make requests resulting in the singer staying near this dwarf for some time.
3. Dancer. This dwarf will typically hang out in a meeting area and offer to dance with any dwarf that is there for social time (not eating/drinking).
4. Therapist. This dwarf will require an office with at least 2 chairs (probably defined by the chair, or a new item... 'Therapist chair'). Will talk out problems with unhappy dwarfs who come to visit. Typically only visited by unhappy dwarfs and sometimes a visit will be a required part of a punishment (for example, violent crimes).
5. Food/drink service. This dwarf will bring food and drink to the table for the hungry and tired. Drink will require a mug. Possibly preempting the arrival of the hungry one if the food/drink service staff are close to the stockpile and are not busy.
-also the possibility of having drink runners. No reason that my miner needs to come allllll the way back to the 2nd level to drink when I could send a non-skilled dwarf to bring the drink to him!
6. [your idea here] need more interesting jobs!